Forum Discussion

Thulasiraman's avatar
Thulasiraman
Icon for Helper II rankHelper II
3 years ago

Combine files from folder

Hi    I have more than 100 excel files in a Folder which I would like to combine throug Power query.  Most of the files have same number of columns (for example 8 columns) except few which have dif...
Need Help
serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
3 years ago

Hi,

you can use something that is in that video.

When you get your table with all the table of data

if you expand you hard code the names of columns

So next time you will not get columns if they increase.

Instead if you use Table.Combine you make it dynamic and all columns will be recovered

Click fx

obtain this

then modify it 

= Table.Combine( #"Filtered Rows1"[Data])

and it's done

 

 

 

 

 

Thulasiraman's avatar
Thulasiraman
Icon for Helper II rankHelper II
3 years ago

Hi serpiva64 

 

Thanks for the suggested solution.  Will try and come back.