Mapping Data to see how many unique characteristics are there

[LeeZH1998]

How do I find out which type of characteristic is most prevalent in which type of fruit? I am very lost right now, help

😕

Food	Type of Food	Characteristic 1	Characteristic 2
Mango	Fruits	Sweet, Sour	Soft, Chewy
Spinach	Vegetable	Bitter, Sour	Soft, Long
Steak	Meat	Salty, Spicy	Chewy, Grainy
Gummy Bear	Candy	Sweet, Sour	Chewy, Flavourful
Cabbage	Vegetable	Sweet, Spicy	Crunchy
Duck Meat	Meat	Salty, Sweet	Chewy, Crispy

[atcodedog05]

Hi @LeeZH1998 ,

Can you give us the logic behind it.

How do to tag a characteristic as most prevalent if there any condition?

Can you provide some sample output.

[LeeZH1998]

I apologize as I must have asked it in a confusing fashion, my sample output would be something like this

Input
Food	Type of Food	Characteristic 1	Characteristic 2
Mango	Fruits	Sweet, Sour	Soft, Chewy
Spinach	Vegetable	Bitter, Sour	Soft
Steak	Meat	Salty, Spicy	Chewy, Grainy
Gummy Bear	Candy	Sweet, Sour	Chewy, Flavourful
Cabbage	Vegetable	Bitter, Spicy	Crunchy
Duck Meat	Meat	Salty, Sweet	Chewy, Crispy
Output
Type of Food	Characteristic	Count	Percentage
Fruits	Sweet	1	25%
Fruits	Sour	1	25%
Fruits	Soft	1	25%
Fruits	Chewy	1	25%
Vegetables	Bitter	2	33%
Vegetables	Sour	1	17%

[atcodedog05 · Accepted solution]

Hi @LeeZH1998 ,

Here is a workflow for the task.

Input

Output

Hope this helps : )

If this helps please mark the post as solution.

[LeeZH1998]

Thank you so much! Cheers to you!

[LeeZH1998]

Hi @atcodedog05, apologies for another quick question,

Input
Food	Type of Food	Characteristic 1	Characteristic 2
Mango	Fruits	Sweet, Sour	Soft, Chewy
Spinach	Vegetable	Bitter, Sour	Soft
Steak	Meat	Salty, Spicy	Chewy, Grainy
Gummy Bear	Candy	Sweet, Sour	Chewy, Flavourful
Cabbage	Vegetable	Bitter, Spicy	Crunchy
Duck Meat	Meat	Salty, Sweet	Chewy, Crispy

Type of Food	Type of Characteristic	Characteristic	Count	Percentage
Fruits	Characteristic 1	Sweet	1	25%
Fruits	Characteristic 1	Sour	1	25%
Fruits	Characteristic 2	Soft	1	25%
Fruits	Characteristic 2	Chewy	1	25%
Vegetables	Characteristic 1	Bitter	2	33%
Vegetables	Characteristic 1	Sour	1	17%

Is it possible for Alteryx to have this sort of output? This new one would require another additional column detailing which characteristic was this sorted from. Thanks!

[atcodedog05]

Hi @LeeZH1998 

Sure definitely its possible. I will take a quick look at it.

[atcodedog05 · Accepted solution]

Hi @LeeZH1998 ,

Here is a workflow for the task.

Output

Workflow

Use select to remove un needed columns

Hope this helps : )

If this helps please mark the post as solution.

[LeeZH1998]

This really does help! Thanks so much!

[atcodedog05]

Happy to help : ) @LeeZH1998 

Cheers and happy analysing : )