Using the List technique in Power Query to recombine tables

Рет қаралды 5,081

Access Analytic

Күн бұрын

Пікірлер: 41

@ExcelOnTheRoad 3 ай бұрын

Awesome video Wyn!

@AccessAnalytic 3 ай бұрын

Cheers Giles

@Bhavik_Khatri 2 ай бұрын

Here is another excellent Wyn List presentation.

@AccessAnalytic 2 ай бұрын

Cheers !

@chilaw2004 3 ай бұрын

You’ve got a great teaching style, Wynn. Easy to listen to and follow.

@AccessAnalytic 3 ай бұрын

Thank you. I appreciate the kind comment.

@GeertDelmulle 3 ай бұрын

Lists are the secret weapons of PQ-M! 🙂

@huseyinburaktasci1638 3 ай бұрын

A pragmatic solution! Thanks a lot Wyn!! ☺

@AccessAnalytic 3 ай бұрын

No worries. You’re welcome.

@zzota 3 ай бұрын

Thanks, Wyn. I'm starting to edit my M code rather than using built-in steps, thank to your guidance. Lots of functions to remember!

@AccessAnalytic 3 ай бұрын

That’s definitely the big challenge when you’re not using it all the time

@cristianprifti 3 ай бұрын

Really simple explained! Thank you also fot the Shift + shortcuts, had no idea about them :)

@AccessAnalytic 3 ай бұрын

You’re welcome. Thanks

@raimundojs9547 3 ай бұрын

Excellent! 💚

@chiragdabhi4929 3 ай бұрын

Before that we use index function this is awesome !!

@AccessAnalytic 3 ай бұрын

We did indeed!

@kebincui 3 ай бұрын

Super! Thanks Wyn and look forward to more videos like this 👍

@AccessAnalytic 3 ай бұрын

Cheers

@sherryfox227 3 ай бұрын

Wyn, this is great!

@AccessAnalytic 3 ай бұрын

Cheers

@mnowako 3 ай бұрын

Excellent! Thank you!

@AccessAnalytic 3 ай бұрын

You’re welcome.

@chrism9037 3 ай бұрын

Thanks Wyn, very useful!

@AccessAnalytic 3 ай бұрын

No worries

@aman_mashetty5185 3 ай бұрын

simply awesome speciall the shortcut

@AccessAnalytic 3 ай бұрын

Cheers 😀

@Haitham_ELtahan 3 ай бұрын

I don't have word just ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

@AccessAnalytic 3 ай бұрын

Hah! Yeah this is a great technique suggested by fellow commenters . 💙DataCommunity

@shubhabratadey 3 ай бұрын

Really cool. Thanks for sharing this

@AccessAnalytic 3 ай бұрын

You’re welcome

@westleyempeigne6541 3 ай бұрын

That’s amazing!

@AccessAnalytic 3 ай бұрын

Thanks for letting us know

@iduncanw 3 ай бұрын

Definitely some great functions, but what's scary is that something like that is needed (ie lots of really badly setup spreadsheets everywhere).

@AccessAnalytic 3 ай бұрын

Sadly it’s normally the fault of the central system export design. Far too often export to Excel or CSV generates this sort of nonsense.

@iduncanw 3 ай бұрын

@@AccessAnalytic true. I had a system that had an export to Excel option.... It exported the file as XML which I'm pretty sure the average user has no idea what to do with and what's more it warned you that it might be a dangerous file.

@sledgehammer-productions 3 ай бұрын

Cool!

@williamarthur4801 3 ай бұрын

any ideas about making page size dynamic for if not all 3? re naming i took the first 3 Source ; List.Transform( List.Split( List.Combine( Table.ToRows( Source )), 3 ), (A)=> Table.FromRows( {A}, List.FirstN( Table.ColumnNames( Source),3) ))

@AccessAnalytic 3 ай бұрын

Without a column name identifier and without a consistent number of columns it would be difficult to build the logic that would be guaranteed to work in all scenarios