Using an input file to change Column Headers

[Paul_s_Moody]

Hi,

I'm using a workflow that will be used to transform blocks of client data into a more suitable format for downstream processes.

I'm hoping to use an (Input) data table to update column headers rather than a Select tool because the input column names may differ per client data set but the output column names will be fixed.

Then all I have to do in the workflow is to point at a consistent column mapping table for each set of client data.

This seems more "auditable" and less prone to typing errors than having to manually update the Select tool for each set of client data.

Is this approach possible?

Thanks in advance!

[ShankerV]

Hi @Paul_s_Moody 

If you are sure that the header/heading only will change. The schema and other column order will remain same.

Then you can use the dynamic rename tool to change the column headers as it is fixed in output.

Many thanks

Shanker V

[ShankerV]

Hi @Paul_s_Moody 

I have used a sample to explain how you can apply in your dataset.

My Input Data Set:

My Input for Fixed column names where I don't want to change each time for each input:

Expected output:

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[Paul_s_Moody]

The number of columns is different in my client data set compared to the mapping table as not all column headers need to change.

Referring to your example: I'd only be looking to change header "AB" to "Fixed Column 2" and "C" to "Fixed Column 3"; Header "A" should remain unchanged.

Does this make sense?

[ShankerV · Accepted solution]

Hi @Paul_s_Moody 

Yes, Its possible. 

Please see the below output.

Many thanks

Shanker V