Joining with a condition

[AIPH123]

Hi All, I have 2 data sets as shown below. Can you please help me merge them together as shown below in the output

Table 1 :

Customer ID	30 days	60 Days	90 days	120 days	365 days
12345	1	0	1	0	0
6789	1	1	1	0	0
10234	1	0	0	1	0

Table 2: 

Customer ID	Product 1	Product 2	Product 3	Product 4	Product 5
12345	Table	Chair
6789	Table	Chair	Stool
10234	Shoe	clothes

Output :

Customer ID	30 days	60 Days	90 days	120 days	365 days
12345	Table	0	chair	0	0
6789	Table	Chair	Stool	0	0
10234	Shoe	0	0	Clothes	0

[echuong1 · Accepted solution]

You can pivot the data in both tables to get the values, and then join back together.

See attached. Hope this helps!

[atcodedog05 · Accepted solution]

Hi @AIPH123 ,

Here is a workflow for the task.

Hope this helps : )

If it helps please mark the post as solution

[AIPH123]

Thank you very much. This worked!