Json File generation from Redshift Table

[Aravind711]

Hi All,

I am working on generating a JSON file from a Redshift table in the below desired format

Required Output:

{
“data”: [
{
“classification_code”: “ARGENTINA”,
“reporting_country”: “Argentina”,
“sub_region”: “Rest of Latin America”,
“territory”: “LA”,
“global_region”: “Americas”,
“worldwide”: “Worldwide”,
“pos_customer_id”: 8,
“pos_customer_site_id”: 13
}
]
}

But My original Output is like the below from Snaplogic

{
“classification_code”: “ARGENTINA”,
“reporting_country”: “Argentina”,
“sub_region”: “Rest of Latin America”,
“territory”: “LA”,
“global_region”: “Americas”,
“worldwide”: “Worldwide”,
“pos_customer_id”: 8,
“pos_customer_site_id”: 13
}

Can any one guide me to get the Required output ( I need the Data Tag to be hard coded, as it is required for the UI development )

Thanks,
Aravind

[cstewart]

You should try using the Group By Field as follows:

For input data:

Result is: