Forum Discussion
Solved
Inconsistent file transformations from combine file in Dataflow
I have an existing dataflow where the source is set to a Sharepoint folder. The dataflow then filters for the CSV file with the most recent "creation date" and I used the "Combine file" option to exp...
Follow these steps:
- go to the "Transform file from Query" > "Helper Queries" > (query) "Transform Sample File"
- Find the Source step and in the formula bar remove the "Columns = 20," from the code
This change will make sure that you always get all the columns from every single file. It won't be set to a specific number of columns anymore.
Follow these steps:
- go to the "Transform file from Query" > "Helper Queries" > (query) "Transform Sample File"
- Find the Source step and in the formula bar remove the "Columns = 20," from the code
This change will make sure that you always get all the columns from every single file. It won't be set to a specific number of columns anymore.
I didn't know it was an optional field. Thanks!