How do I find out which type of characteristic is most prevalent in which type of fruit? I am very lost right now, help 😕 FoodType of FoodCharacteristic 1Characteristic 2MangoFruitsSweet, SourSoft, ChewySpinachVegetableBitter, SourSoft, LongSteakMeatSalty, SpicyChewy, GrainyGummy BearCandySweet, SourChewy, FlavourfulCabbageVegetableSweet, SpicyCrunchyDuck MeatMeatSalty, SweetChewy, Crispy Alteryx Sample.xlsx

Mapping Data to see how many unique characteristics are there

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

😕

Preparation

Here is a workflow for the task.

Input

Output

Hope this helps : )

If this helps please mark the post as solution.

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.

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.

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