AnsweredAssumed Answered

Split by json profile element (unique value)

Question asked by ben_miller246102 Employee on Nov 14, 2017
Latest reply on Nov 15, 2017 by Lee Sobotkin

Below is my json.  I want to split it such that IF pm_code differs that each unique pm_code will be in it's own json object.  The below json should ideally run through the process and NOT get split because the pm_codes are the same.  Every time I try, it splits the below file even though they are the same code.  Hopefully I'm just doing it wrong and this is possible.  

 

 

{
"line" : {
"part" : "261871",
"domain" : "US",
"sites" : [
{
"site" : "25",
"pm_code" : "L"
},
{
"site" : "31",
"pm_code" : "L"
}
]
}
}

Outcomes