Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

manipulating the data

LoisGower
7 - Meteor

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 noStyle DescriptionSize
1234Hoodie OrangeL
1234Hoodie GreenL
1234Hoodie OrangeM
2345JeansM
2345Polo BlueS
2345Polo BlueS

 

And I want to turn into this;

 

Customer noStyle DescriptionSizeStyle DescriptionSizeStyle DescriptionSize
1234Hoodie OrangeLHoodie GreenLHoodie OrangeM
2345JeansMPolo BlueSPolo BlueS

 

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. 

9 REPLIES 9
Jean-Balteryx
16 - Nebula
16 - Nebula

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
16 - Nebula
16 - Nebula

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

LoisGower
7 - Meteor

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

Jean-Balteryx
16 - Nebula
16 - Nebula

Thank you ! You are welcome @LoisGower !

mtouiti
Alteryx Alumni (Retired)

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
Alteryx Alumni (Retired)

Great solution @Jean-Balteryx loved the logic. 

atcodedog05
22 - Nova
22 - Nova

Hi @LoisGower 

 

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

 

Workflow:

atcodedog05_0-1627658276251.png

 

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
16 - Nebula
16 - Nebula

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

LoisGower
7 - Meteor

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

Labels