Forum Discussion
Advocate IIICombining 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
- Vvelarde
Community Champion
hi Caitlin_Knox
i created a video to follow the steps to one way to solve this:
Let me know if helps you.
- MarcelBeug
Alternatively, instead of first adjusting the main query and applying the modifications to the example query, you can also directly adjust the example query.
- Vvelarde
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).
