โ11-30-2020 07:18 AM
Hi
I have a set of data from ServiceNow that use a different header for each record and I would like to flatten this data to a single level. But I am not sure how as each header is different. See the example below;
{
"RITMNumber": "RITM3993",
"number": "SCTASK8011",
"RITM3993": {
"requested_for": "Pal",
"location": "Home"
},
{
โRITMNumberโ: โRITM3791โ,
โnumberโ: โSCTASK7217โ,
โRITM3791โ: {
โrequested_forโ: โBobโ,
โlocationโ: โWorkโ
}
I would like, i.e. lose the headers RITM3993, RITM3791,โฆ
{
"RITMNumber": "RITM3993",
"number": "SCTASK8011",
"requested_for": "Pal",
"location": "Home"
},
{
โRITMNumberโ: โRITM3791โ,
โnumberโ: โSCTASK7217โ,
โrequested_forโ: โBobโ,
โlocationโ: โWorkโ
}
Any help much appreciated.
โ11-30-2020 08:53 AM
See attached pipeline segment.CS-XXX_2020_11_30.slp (4.6 KB)
โ11-30-2020 09:05 AM
Doh, that was easy.
Thanks