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

@umashankar_cns this can be achieved using json parse tool

Json_Parse_19032025.yxmd