Alteryx Designer Desktop Discussions

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

Return the Field Name if true and Concatenate the Field Names

YLYONG
9 - Comet

Hi Fellow Alteryx members,

 

I am working out how to concatenate all only where the Delivery Day is "1"

Can you please help!

Thank you

 

 MonTueWedThuFri
Acer10001
Lenova01000
HP00011
Dell01110

 

Output

 

 Delivery Day
AcerMon, Fri
LenovaTue
HPThu, Fri
DellTue, Wed, Thu
3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

@YLYONG 
Maybe you can share what you have so far, then we can try to assist from there?

flying008
14 - Magnetar

Hi, @YLYONG 

 

Maybe this is your want: 

 

录制_2023_02_20_10_57_01_655.gif

YLYONG
9 - Comet

 

@Qiu 

Here is it, achieved the output :) 

 

@flying008 thank you for the solution provided

 

YLYONG_0-1676866678354.png

 

Labels