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