Hello, I am trying to combine multiple excel files in a folder. I was able to remove the trash rows, promote the headers (in transform sample file) in transform/query. Then remove the change data type and use "detect data type" to get rid of an error. Unknown to me until now. There are some schema issues in the file. Some columns names are present in one file, but not there other. Familar with FieldsMissing.Ignore. How do I ignore the schema issues and bring in columns that are shared among the two? New users. Thanks for any pointers.

Hi gordgord1, the correct approach depends on how you're using that/those missing column(s). If you don't need the column in your report, you can set the file where the column is missing as the Sample File that is used as the "master" defining all the columns you expect in the other files too. You can do that either during the "Combine Files" step if you select "Combine & Transform" or by adjusting the Sample File in the Helper Queries: If you do need the column but can accept that you'll have some null values, you can select the file that includes the column(s) as your Sample File instead. In that case the column will contain null-values for all rows of the sources that didn't contain the column.

Excel with different Schema (Missing Columns Errors)

Forum Discussion

Related content

Inferring Missing Columns and Imputing Missing Data

missing data

Total value missing in calculated column

Generating Missing Data

Missing information