Forum Discussion

aprabhav's avatar
aprabhav
New Contributor III
3 years ago

How to handle SERIAL column while using Postgres Bulk Load Snap

I am trying to use a Postgres Bulk Load snap. But my table has a serial column (viz. id). I tried a couple of things but the postgres bulk load snap fails due to various errors as my input data does ...
JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago

Hi @bojanvelevski ,

I Have another question about the same scenario but little more difficult.
So the output is this.

AllData{​​​​​

Dataset1
    [{​​​​​Fieldname:Fieldname1
        Value: Value1}​​​​​,
    {​​​​​Fieldname:Fieldname2
        Value: Value2}​​​​​],     
Dataset2[]

}​​​​​
The goal is to change every fieldname to the value of the fieldname like you showed. But this needs to be done for every Dataset. This is to get all the columnames from an SQL Server.

Thank you in advance

bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

$AllData.mapValues((v,k)=>v.map(x=>x.mapKeys((v1,k1)=v1)))

I belive something like this should work