Json File generation from Redshift Table
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”: ...
Forum Discussion
Thanks @cstewart
I don’t want the data to be repeated, i followed the steps you said and got the output as like the above screenshot.
Please suggest a way to get data like
{
“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
},
{
“classification_code”: “ARGENTINA”,
“reporting_country”: “Argentina”,
“sub_region”: “Rest of Latin America”,
“territory”: “LA”,
“global_region”: “Americas”,
“worldwide”: “Worldwide”,
“pos_customer_id”: 9,
“pos_customer_site_id”: 15
},
{
“classification_code”: “ARGENTINA”,
“reporting_country”: “Argentina”,
“sub_region”: “Rest of Latin America”,
“territory”: “LA”,
“global_region”: “Americas”,
“worldwide”: “Worldwide”,
“pos_customer_id”: 10,
“pos_customer_site_id”: 15
}
]
}
This is what, I did in JSON generator, PFB screenshot
Below is my pipeline
You should try using the Group By Field as follows:
For input data:
Result is:
