Forum Discussion
Import Query - Sample File from Folder doesn't read data
Hi I have a folder with excel files that have multiple sheets in them which holds the same data table structure and I need to consolidate them. I approach this as I do with normally - get data > f...
Anonymous
I guess you use the button in Content column? If so, add a custom column instead, combine the tables in Custom column. Let me know if it is not the case.
Hello,
Can you please check if the files that your are using from within the folder have same structure for all of them?
Also, please share your Advanced Editor code for both the above cases to take a deeper look.
Hi you are correct the order of the sheets have changed over time due because of renaming the "Dalgety" sheet to "Landing" - to reflect real life changes.
Is there a way I can dynamically look for these two sheets and merge them as one in power query?