โ03-21-2022 01:41 AM
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.
Solved! Go to Solution.
โ03-21-2022 01:49 AM
โ03-21-2022 01:49 AM
โ03-21-2022 02:05 AM
Thank you for your answer.
I See it now. It Works
โ03-21-2022 03:26 AM
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
โ03-21-2022 03:33 AM
$AllData.mapValues((v,k)=>v.map(x=>x.mapKeys((v1,k1)=v1)))
I belive something like this should work