Create a categorization with combinations of products owned

[D_Wenz_07]

Hi. everyone! Hope all is well. 

I really need some help cleaning my data into one column that defines which customers own which products. Below (and attached) is a snapshot of my data set input and desired output. I have been racking my brain to come up with a clean solution, but to no avail. I am dealing with a large data set and several different combinations, so I was hoping there was an easier way. I would appreciate any help or guidance. 

[AngelosPachis · Accepted solution]

Hi @D_Wenz_07 ,

You have to transpose all the columns that contain the product flag and then come up with a way to only keep the product type (A, B, C..). I have removed "Has product " from the name column. Then if you summarize and concatenate all relevant products to each customer ID you will get what you are looking for

Hope that helps,

Angelos

[Qiu · Accepted solution]

@D_Wenz_07 

Hope this helps.

[Emil_Kos]

Hi @D_Wenz_07 

I have created a workflow for you:

The output:

Good Luck!