Joining with a condition

Question

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 ID30 days60 Days90 days120 days365 days12345101006789111001023410010

Table 2:

Customer IDProduct 1Product 2Product 3Product 4Product 512345TableChair   6789TableChairStool  10234Shoeclothes

Output :

Customer ID30 days60 Days90 days120 days365 days12345Table0chair006789TableChairStool0010234Shoe00Clothes0

echuong1 · Accepted Answer

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

See attached. Hope this helps!

atcodedog05 · Accepted Answer

Hi @AIPH123 ,

Here is a workflow for the task.

Hope this helps : )

If it helps please mark the post as solution