Forum Discussion

alee023's avatar
alee023
Frequent Visitor
2 years ago
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...
  • miguel's avatar
    miguel
    2 years ago

    Follow these steps:

    1. go to the  "Transform file from Query" > "Helper Queries" > (query) "Transform Sample File"
    2. 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.