Forum Discussion
Removed rows not actually removed
When you remove top rows and promote headers in the main query, that applies only once for the combined data, not for each individual file.
If you want to perform transformations for each individual file, you should adjust the Transform Sample File query, instead of the main query.
The code in the Transform Sample File query, is directly linked to the function that is applied to all files.
Hi Anonymous,
I did turn on those steps and applied the changes, I clicked back through the steps to show for my post what wasn't happening.
Community ChampionWhen you remove top rows and promote headers in the main query, that applies only once for the combined data, not for each individual file.
If you want to perform transformations for each individual file, you should adjust the Transform Sample File query, instead of the main query.
The code in the Transform Sample File query, is directly linked to the function that is applied to all files.