Reading in file weekly, header name slightly changes, how to deal with this.

[wonka1234]

Hi,

I have a weekly file that i run a workflow on.. however 1 header changes . Ie  It changes from  Name 123, next week will be Name 124.

I need this column and because it changes my append fields do not work and it throws off the entire workflow.

Is there a way to change column header beginning with Name to be hardcoded so I can always pickup this header?

Thanks.

[ed_hayter · Accepted solution]

You could do a dynamic rename to do this.

[Luke_C]

Hi @wonka1234 

You could try the dynamic rename tool with the formula option. Something like the below should work:

if Startswith([_CurrentField_],'Name ') then 'Name' else [_CurrentField_] endif