Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic Rename Columns

lipster26
7 - Meteor

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

 

lipster26_0-1616085434395.png

 

Thanks for any help!

 

2 REPLIES 2
jamielaird
14 - Magnetar
lipster26
7 - Meteor

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.

Labels