Rename the fields in a dataset

[Ronal_bal]

Hi, I'm trying to rename the fields of a dataset. But Columns I need to rename is 70. 

Example below. Any idea? I tried with dynamic rename bit I don't have input header for 70 columns.

[DataNath · Accepted solution]

@Ronal_bal, do you have any more details regarding the logic of this rename? For your example, you could simply use a formula in the dynamic rename, rather than current and new header columns. In this case, because you're using formula, it makes no difference how many fields you have.

Before:

After:

Workflow attached - you obviously just need to change 'XYZ' and 'ABC' to your target and replacement requirements, respectively.