Data Transformation

[howyoudoing]

Hi! Could you please help me how to transform this data from file 20 to output 20? Which tool I should use?

[binuacs · Accepted solution]

@howyoudoing you can try with the summarize tool

group by category,color

and take the count of the state field

[Chaoued]

@howyoudoing  Hello, you will find attached the workflow with the desired output...
just correct the color and use the group by tool

[nagakavyasri]

@howyoudoing