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!
Hi @lipster26 ,
There's a tool for that 😉
Check out https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Tool-Mastery-Dynamic-Rename/td-p/42483... for more.
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.