Forum Discussion

JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago
Solved

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

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.

4 Replies

    • JensDeveloper's avatar
      JensDeveloper
      Contributor II

      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

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

        I belive something like this should work