APQ06: Advanced Power Query Video #6 - M-CODE - Table.Combine

[@michafabich9213]

excellent thanks for this advanced series....very valuable content

[@AAAExcel]

My pleasure 🙏🙏

[@aniljaggarwal60]

👌 Excellent 👌 thanks 👌

[@AAAExcel]

Most welcome 🙏

[@alexrosen8762]

The best solution to this situation I have seen this far 👌

[@AAAExcel]

Thank you 🙏

[@AbdulHalim-s5o8h]

Excel ❤. I have learned more things from you Videos

[@AAAExcel]

Thank you 🙏

[@jawadahmadehssan6251]

Thanks Amar for another great transformational tricks.

[@AAAExcel]

My pleasure

[@MrFredy65]

Excellent.....Thanks....I hope your videos....

[@AAAExcel]

Most welcome dear, I will do my best

[@billgillaspey9036]

Q: Why does Table.Combine( Source ) not require { } (perhaps { Source } ); at other times when a list is required, the {}'s are required...

[@AAAExcel]

in video you will notice that source step contains nothing but a list, that's why when you pass it inside the function Table.Combine, you are not required to add the curly brackets. This will also be the case if you pass a column to a function requiring a list. Normally you need the {} when you are passing hardcoded lists such as {1,2,3}

[@SeyPras.]

Thanks for the tutorial Sir.. The code had so little steps. Was thinking you could also wrap the Table.combine within the source step as well

[@Mohamed-km9jd]

This is very usefull and I want to know If i am getting data from folder and the folder has multiple pdf files with different number of table in each pdf. What should u do??

[@AAAExcel]

Try to transform the first file first, change the query to a custom function then apply the custom function to the rest of the folder

[@shoaibrehman9988]

Wise technique 👌. A question if any 1 or few tables columns headers are not in sequence, could be Date , category, Qty or Table 2 Supplier, Qty. Date . How can we handle this situation. If any thoughts pls share with us.

[@AAAExcel]

Thank you .. sequence never impact the append/combine process

[@khalidmajeed2886]

sir, too easy than before

[@AAAExcel]

True .. totally agree

[@sazdean7233]

This is great thanks. Would you like to try to solve this challenge which I'm encountering, If we have a table like this: Person, Car A, K A, L B, M B, N B, O C, P And we want to turn it into this table: A, B, C K, M, P L, N, null null, O, null How do you think we can do it in Power Query, knowing that more Persons and Cars can be added in the future. so the query has to be dynamic. I find this incredibly challenging Thanks

[@AAAExcel]

Please try the below simple code let Source = Excel.CurrentWorkbook(){[Name=“Table1”]}[Content], Grouped = Table.Group(Source, {“Person”},{{“Car”, each _[Car]}}), Result = Table.FromColumns(Grouped[Car], Grouped[Person]) in Result