Using an input file to change Column Headers

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!

Common Use Cases

Transformation

Preparation

Accepted answers

ShankerV

Hi @Paul_s_Moody

Yes, Its possible.

Please see the below output.

Many thanks

Shanker V

Dynamic rename.yxmd

All comments

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

Dynamic rename.yxmd

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

Hi @Paul_s_Moody

Yes, Its possible.

Please see the below output.

Many thanks

Shanker V

Dynamic rename.yxmd

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235