Parse concatenated json objects

[umashankar_cns]

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

[binu_acs · Accepted solution]

@umashankar_cns this can be achieved using json parse tool

[umashankar_cns]

Thanks !