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

Question

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 Answer

You could do a dynamic rename to do this.