Forum Discussion
Combine files from folder
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.