Combining Binaries

[Caitlin_Knox]

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?

[Vvelarde · Accepted solution]

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]

@MarcelBeug

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).