Forum Discussion
Combine Data from a folder where contained files have a different number of columns
Hi Mstanford,
in the main and Transform query remove all references to column names - typically it would be #Changed Type step - until it comes to the Append step.
If you followed a typical way of creating it (i.e. using the export assistant), the code also has Expanded Columns step, which is also a problem as you nee dto list column names there (and it typically refers to the first file structure). Instead, you need to do something like this:
Combine = Table.Combine(#"Added Custom"[Data])Where #"Added Custom"[Data] refers to a column with the exported data from the files (the step imideatelly before the #"Expanded Something").
If you need more detail, please share your main query code in the part which preceeding the Expanded step.
Kind regards,
John
Hi Mstanford,
in the main and Transform query remove all references to column names - typically it would be #Changed Type step - until it comes to the Append step.
If you followed a typical way of creating it (i.e. using the export assistant), the code also has Expanded Columns step, which is also a problem as you nee dto list column names there (and it typically refers to the first file structure). Instead, you need to do something like this:
Combine = Table.Combine(#"Added Custom"[Data])Where #"Added Custom"[Data] refers to a column with the exported data from the files (the step imideatelly before the #"Expanded Something").
If you need more detail, please share your main query code in the part which preceeding the Expanded step.
Kind regards,
John
ah, this is perfect, thank you!