Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Parse concatenated json objects

umashankar_cns
6 - Meteoroid

Hi Experts

I am illustrating a sample output using a sql query

STATE   PERSONAL_DETAILS (json)

NH             {"Name":"John","Age":"21"}

MA             {"Name":"Jonathan","Age":"25"}

NH             {"Name":"Mark","Age":"22"}

 

Using Summarize , Grouping done

NH             {"Name":"John","Age":"21",},  {"Name":"Mark","Age":"22"}

MA             {"Name":"Jonathan","Age":"25"}

 

I need the following output

NH            John, Mark

MA            Jonathan

 

Can this output be generated using standard tools available ?

 

Thanks,

Umashankar

 

 

2 REPLIES 2
binuacs
21 - Polaris

@umashankar_cns this can be achieved using json parse tool

image.png

umashankar_cns
6 - Meteoroid

Thanks !

Labels
Top Solution Authors