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
| Mon | Tue | Wed | Thu | Fri | |
| Acer | 1 | 0 | 0 | 0 | 1 |
| Lenova | 0 | 1 | 0 | 0 | 0 |
| HP | 0 | 0 | 0 | 1 | 1 |
| Dell | 0 | 1 | 1 | 1 | 0 |
Output
| Delivery Day | |
| Acer | Mon, Fri |
| Lenova | Tue |
| HP | Thu, Fri |
| Dell | Tue, Wed, Thu |
Solved! Go to Solution.
@YLYONG
Maybe you can share what you have so far, then we can try to assist from there?
