Hello everyone,
I have a workflow with the following inputs:
Work Received | 2019/10/01 | 2019/10/03 | 2019/10/04 | 2019/10/07 |
Client 1 | 3 | 1 | 6 | 7 |
Client 2 | 16 | 8 | 1 | 8 |
Client 3 | 3 | 20 | 11 | 19 |
Work Done | 2019/10/01 | 2019/10/03 | 2019/10/04 | 2019/10/07 |
Client 1 | 5 | 14 | 5 | 9 |
Client 2 | 14 | 11 | 13 | 14 |
Client 3 | 2 | 9 | 20 | 3 |
However I need a table with the following format:
2019/10/01 | 2019/10/03 | 2019/10/04 | 2019/10/07 | ||
Client 1 | Done | 14 | 1 | 5 | 1 |
Client 1 | Received | 3 | 1 | 6 | 7 |
Client 2 | Done | 10 | 12 | 5 | 20 |
Client 2 | Received | 15 | 13 | 4 | 5 |
Client 3 | Done | 8 | 5 | 18 | 5 |
Client 3 | Received | 9 | 2 | 7 | 13 |
Is it possible to achieve this output in Alteryx?
Solved! Go to Solution.
Hey @krmplt
I think a simple union may be all you need here!
You will need to rename your client name so they are the same in both datasets and you'll probably want to create a new column for "Done" and "Received"
Worked brilliantly, thank you very much!
Hi @krmplt,
It looks as though you simply need to create the "Received" and "Done" columns through a formula tool and union together.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.
Regards,
Jonathan