Member since
12-14-2023
1
Post
0
Kudos Received
0
Solutions
12-14-2023
05:54 AM
Hi @Eva0 , You were close . I think the first astrik "*" was not needed because the input json is not contained in an array brackets. Then to include the email in each data element it has to be added at the date & type level but to reference the value you need to go to 2 levels up using the @ character as in @(2,mail) where the email is located in relative to date & type. [
{
"operation": "shift",
"spec": {
//level 2 where email originally is
"dates": {
// level 1
"*": {
// start count here at level 0
"@(2,email)": "[&1].email",
"date": "[&1].date",
"type": "[&1].type"
}
}
}
}
] If you find this helpful please accept solution. Thanks
... View more