JSON field to Postgres

Hi All,

I wanted to transform JSON data and move to different columns and load it to Postgres.

Input :
{
“v” : {
“f” : [ {
“v” : “Asia”
}, {
“v” : “India”
}, {
“v” : “Tamil Nadu”
}, {
“v” : “”
}, {
“v” : “Southern Asia”
}, {
“v” : “(not set)”
} ]
}
}

Expected Output :

1st column = Asia
2nd column =India
3rd column =
4th column = Southern Asia
5th Column = not set

Can anyone help me in this?

@ana_ved @ArjenEX @mlauber71

Hi @sridhar5999

Tagging people is usually not appreciated, it doesn’t get you a solution faster :wink:

To get this, use a JSON Path node with a collection query on $['v']['f'][*]['v'] and output it as list.

Next, with a Split collection node to can create the desired columns.

4 Likes