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 MonTueWedThuFriAcer10001Lenova01000HP00011Dell01110 Output Delivery DayAcerMon, FriLenovaTueHPThu, FriDellTue, Wed, Thu

Return the Field Name if true and Concatenate the Field Names

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

Output

Workflow

Maybe this is your want:

录制_2023_02_20_10_57_01_655.gif

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

Maybe this is your want:

录制_2023_02_20_10_57_01_655.gif

Here is it, achieved the output

@flying008 thank you for the solution provided