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?
