ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Return Column Header if Value is "1"

YLYONG
Cometa

Hello!

 

Need help in identifying a smarter way to return the column header if the value is "1"

 

Parent TU IDHas_AIOHas_COMHas_CPSHas_DG1Has_MO1Consolidation Type
20246464010010AIO -> DG1
20235888011000AIO -> COM
20263492010011AIO -> DG1 -> MO1
20261184011000AIO -> COM
20264130010100AIO -> CPS

 

YLYONG_0-1656652747922.png

 

Thank you for your help once again!

 

3 RESPUESTAS 3
grazitti_sapna
Cástor

Hi @YLYONG , give this a try.

grazitti_sapna_0-1656653889150.png

 

 

Thanks!

Sapna Gupta
binu_acs
Polaris

@YLYONG one way of dong this

binuacs_0-1656655957163.png

 

flying008
Aurora

Hi, @YLYONG 

 

Try this way if you like:

 

录制_2022_07_02_14_22_27_238.gif

 

 

Etiquetas
Autores con mayor cantidad de soluciones