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...
Dataflows
Need Help
  • 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.

     

miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
2 years ago

Hi!

Could you please share the Power Query Script (M code) of your exemplar query (sample transform query)? That would help us understand what logic you have implemented.