Dynamic Rename Columns

Question

Hello

Is there a way to dynamically rename columns using other column names?

For example i have a number of columns laid out beside each other:

IncomeLossUSPartnerships

referenceDocumentId

IncomeLossPerIncomeStmtAmt

TemporaryDifferenceAmt

PermanentDifferenceAmt

IncomeLossPerReturnAmt

I'd like to concactenate IncomeLossUSPartnerships to each of the other columns.

referenceDocumentId_IncomeLossUSPartnerships

IncomeLossPerIncomeStmtAmt_IncomeLossUSPartnerships

TemporaryDifferenceAmt_IncomeLossUSPartnerships

PermanentDifferenceAmt_IncomeLossUSPartnerships

IncomeLossPerReturnAmt_IncomeLossUSPartnerships

Thanks for any help!

lipster26 · Answer

Thanks. But how do I do it dynamically so that i don't have to type in _IncomeLossUSPartnerships into the Add box? I just want it to read that column name and add it.

jamielaird · Answer

Hi @lipster26 ,

There's a tool for that 😉

Check out https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Tool-Mastery-Dynamic-Rename/td-p/424836 for more.