manipulating the data

[LoisGower]

hey team,

I need your brains please!! 

I have tried using the cross tab and I just can't get it to work.

This is the raw data;

Customer no	Style Description	Size
1234	Hoodie Orange	L
1234	Hoodie Green	L
1234	Hoodie Orange	M
2345	Jeans	M
2345	Polo Blue	S
2345	Polo Blue	S

And I want to turn into this;

Customer no	Style Description	Size	Style Description	Size	Style Description	Size
1234	Hoodie Orange	L	Hoodie Green	L	Hoodie Orange	M
2345	Jeans	M	Polo Blue	S	Polo Blue	S

and then do some sort of formula to identify if the customer has brought the same product in the same size. So in this example 2345 the blue polo in size S small would be want I wanted to highlight some how.

Any suggestions / flows would be amazing.

Many thanks,

Lois. 

[Jean-Balteryx · Accepted solution]

Hi @LoisGower ,

Here is how you can do it for the cross tabs part ! Fields can't have same name so I added an ID.

[Jean-Balteryx · Accepted solution]

I added a part that retrieves articles bought more than once by a same client.

[LoisGower]

@Jean-Balteryx - THANK YOU SO SO MUCH, YOU GENIUS!! 

[Jean-Balteryx]

Thank you ! You are welcome @LoisGower !

[mtouiti]

hi @LoisGower , in alteryx it will not be possible to call all columns "Style Description" every column should be unique. Therefore you need to think about an output that can be done with alteryx. 

I've tried to create a workflow to get to your result, can you check and let me know what do you think. 

Best 

MO 

[mtouiti]

Great solution @Jean-Balteryx loved the logic. 

[atcodedog05 · Accepted solution]

Hi @LoisGower 

There is a sneaky way to make the column names look same. I am just updating @Jean-Balteryx workflow.

Workflow:

Sneaky way is to add spaces in the column name. This way column name is different but looks same.

Size1 -> "Size"

Size2 -> "Size "

Size3 -> "Size  "

Hope this helps : )

[Jean-Balteryx · Accepted solution]

I updated mine, inspired by @atcodedog05 , to dynamically add the spaces whatever the number of columns.

[LoisGower]

@atcodedog05  and @Jean-Balteryx Thank you both so much! 🙂