merge two tables

[krmplt]

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?

[afv2688 · Accepted solution]

Hope this helps @krmplt 

Regards

[LordNeilLord]

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"

[krmplt]

Worked brilliantly, thank you very much!

[Jonathan-Sherman]

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