How to dynamically rename columns where column could have multiple aliases?

[vasudha_joshi]

Hello,

I am facing some issue with dynamically renaming columns. How to rename columns dynamically in alteryx workflow, suppose I need a column to be named as Account Number in the output file, but the input the header might appear in multiple aliases like AN, AC, Acc. No., Account Num, etc. This is just one example. This scenario is replicated for some 7 more columns.

Attaching my workflow for your reference, I tried with text input and dynamic rename, but its failing with some errors.

Thanks in advance.

Regards,

Vasudha

[afv2688 · Accepted solution]

Hello @vasudha_joshi ,

This may give you a hint about how to do it.

Regards