Forum Discussion
Combine files from folder
Hi serpiva64
Thanks for your reply. Saw the video. I think the video talks about different column names. In my case, I don't have column names at all. But different number of columns in each file.
Is the expected result supposed to include the unknown columns? If they are unknown, how are you using them in your project? Or are you simply trying to combine the data from all files that contain the specific 8 columns and omit the other columns?
Hi jennratten
Thanks for pitching in. Actually the excile files which I am referring are nothing but Sales Invoices generated in excel. It is a standard format with 8 columns being used. But sometimes the clerk uses additional columns for the reasons best known to him. So it happens that some files contain more than 8 columns.
I tried selecting the file with maximum columns as sample file while transforming and combining. It worked. But the problem for me to open all the files and see which file has max columns.
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
