Forum Discussion
Combining Binaries
I'm testing a scenario and not achieving what is expected. I have a local folder than I'm using as my data source. In this folder I begin with one xlsx file. In the data modeling steps, I remove the 1st row and then promote the first row as headers. When another file is added to this folder, these steps are not being applied and I end up with 2 rows in the dataset that shouldn't be there (the first being the row I deleted, and the second being the row that should be considered headers) What am I doing wrong?
hi Caitlin_Knox
i created a video to follow the steps to one way to solve this:
Let me know if helps you.
3 Replies
hi Caitlin_Knox
i created a video to follow the steps to one way to solve this:
Let me know if helps you.
Alternatively, instead of first adjusting the main query and applying the modifications to the example query, you can also directly adjust the example query.
yes, is correct. The video is the long version to explain what is this M Code to Paste in Sample Query. (Remove Rows, and Promote Headers).
