cancel
Showing results for 
Search instead for 
Did you mean: 

Change the key to the value of the value of the key of a String For identifying columns

JensDeveloper
Contributor II

Hello,

So I have a DataSet that looks like this:
{ Name : testvalue1,
Name : testvalue2
}

But I want to change the key ‘Name’ into the value it contains: output

{ testvalue1 : testvalue1,
testvalue2 : testvalue2
}

It’s needed because after that I want to fil all the keys with the right data and do an SQL insert with the Keys as the column names.

1 ACCEPTED SOLUTION

bojanvelevski
Valued Contributor

Hey @JensDeveloper ,

Try this:

$.mapKeys((v,k)=> v)

View solution in original post

4 REPLIES 4

bojanvelevski
Valued Contributor

Hey @JensDeveloper ,

Try this:

$.mapKeys((v,k)=> v)

Thank you for your answer.

I See it now. It Works

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

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

I belive something like this should work