Hi @danielkataoka , there are a couple of ways to go about this, but it’s hard to tell without seeing the structure of your files.
There aren’t much you saying. As I always say, the more info you give, the more precise the solution you will get. “Help us help you”.
So, are we to assume that you want to keep only the columns that exist in all the files, or should the ones that don’t have the additional columns to be filled with EMPTY values?
If it is the former, how are the files with more columns set up? Are the additional columns all after the common columns? If that is the case, then you can choose the option “Read only data in” instead of reading the entire data of the sheet in the “Sheet area” option:
And of course, we want to read all the files at once, which is faster, so we want to read with the “Files in folder” option instead of “File”:
If the columns are in no specific order, I’ll still read all the files at once, but making sure to have the “Support changing file schemas” option on:
You can then do your Column Filter and apply any other rules on the dataset.