"PromoteAllScalars" is promoting a dynamic filename and I need to prevent this

[Guitarmageddon]

Hello all,

When filtering out some rows of null values, then promoting all scalars in first row to headers, it is also taking my source name column, which I would like to retain for possible future use. Problem is, any time I refresh the query its looking for a source name (i.e. filename 8-8, filename 8-9, etc) and causing an error.

Can I "promote all scalars except one"
or....
Possibly, just nest a rename inside the same "promote all scalars" step which could rename column 0 to simply "source name"?

For example, here is where it is promoting all scalars

But then as soon as I refreshed with a later file date, it errors out on the prior date since that's what it was explicitly trying to find in the steps. In this case, I used the "8-9 TST" file as a test for tomorrow. I had originally intended "source name" to be used for the meta data column.

 

[Guitarmageddon]

Also, here is the step immediately preceeding, so you can see where the columns come from. All the other columns are usable and static once promoted. I guess I could bite the bullet and just delete the first column here, but that is more of a bandaid than anything

 

[Guitarmageddon]

Small update, I think this was a simple one, but wanted to share in case some other "intermediate beginner" came along and was stumped.

I just inserted a step immediately after, renaming column zero aka first column, to SOURCE DATE. Referencing column zero versus an explicit name is what did the trick. but if there is a better way to nest this into the large single promote all scalars step, Id love to see that