Forum Discussion
Problem to combine multiple files with different sheet names.
Hi,
Did you load your file, using connection Folder or Excel ?
If you create a connection to a folder, you should have a function (fx), parameters, and a query in the left panel.
The solution you pointed out is in M code (Power Query) and need to be copy and paste on the formula bar (new steps) or in the advanced editor.
But I can offer you a more simple solution, if...
you always need the first sheet (1st sheet = 0, 2nd=1...) of your Excel files, you can also use :
#"Sales_Sheet" = Source{0}[Data]
instead of
#"Sales_Sheet" = Source{[Item="Sales Week 32",Kind="Sheet"]}[Data]
Hope this helps you, let us know
Hi,
Did you load your file, using connection Folder or Excel ?
If you create a connection to a folder, you should have a function (fx), parameters, and a query in the left panel.
The solution you pointed out is in M code (Power Query) and need to be copy and paste on the formula bar (new steps) or in the advanced editor.
But I can offer you a more simple solution, if...
you always need the first sheet (1st sheet = 0, 2nd=1...) of your Excel files, you can also use :
#"Sales_Sheet" = Source{0}[Data]
instead of
#"Sales_Sheet" = Source{[Item="Sales Week 32",Kind="Sheet"]}[Data]
Hope this helps you, let us know
Thanks for your help and i find out how to do.
Also with this youtube movie.
https://www.youtube.com/watch?v=JZSdAvGAq_E