Assistance with grouping and cross-tabbing JSON data

[AKPWZ]

Hi, As a student, this is something new to me; the first time I saw column names appeared under JSON Value String. When I try to group by and use the cross tab tool, I can't place those as column names alongside others. I've attached the sample data as well as the desired output in an excel sheet. Please assist me in learning and completing this task.

I've also highlighted the desired column and its value.

Thank you!

[grazitti_sapna]

Hey @AKPWZ , Can you please provide the JSON input you are providing as an input. Because in the file you shared it will be difficult for Alteryx to read its input.

[AKPWZ]

Hi @grazitti_sapna sharing json input file with you. Thank you!

[AKPWZ]

Hi @grazitti_sapna Have you been able to get what you asked for?

[grazitti_sapna]

@AKPWZ , Let me check got caught up with other things