Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Change column name based on field values

Jarviz
6 - Meteoroid

Hi there, Could you please help me out with the mechanism of dynamically changing the Column header name of Amt?

It should be like if Key is KK then Column Name should be Amt KK.

 

Employee NameDept.KeyAmt AL
JohnPoliceAL2.5
QuinnDoctorKK77.9
FritzEngineerKK0.66
etcetcetcetc
etcetcetcetc
4 REPLIES 4
phottovy
12 - Quasar

You can use the Cross Tab tool to accomplish this. See the attached workflow.

Luke_C
13 - Pulsar

@Jarviz 

 

How should the data ultimately look?  Something like the below? I think a cross tab and a dynamic rename to have a prefix of Amt should work

 

Employee NameDept.Amt ALAmt KK
JohnPolice2.50
QuinnDoctor077.9
FritzEngineer00.66

 

Luke_C_0-1621522557133.png

 

 

 

Jarviz
6 - Meteoroid

It worked thanks you 🙂 @Luke_C

Jarviz
6 - Meteoroid

You are awesome! Thanks

 

@phottovy

 

Labels