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.
