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
ArjenEX
2
Hi @sridhar5999
Tagging people is usually not appreciated, it doesn’t get you a solution faster
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
system
Closed
3
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.