- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2023 10:28 AM
I have to transform documents that look like the following:
[{
“Id”: 999,
“field1”: “value1”,
“field2”: “value2”,
“field3”: “value3”
}
]
Into output like this.
[{
“Id”: 999,
“entity”: {
“path”: “field1”,
“op”: “replace”,
“value”: “value1”
}
},
{
“Id”: 999,
“entity”: {
“path”: “field2”,
“op”: “replace”,
“value”: “value2”
}
},
{
“Id”: 999,
“entity”: {
“path”: “field3”,
“op”: “replace”,
“value”: “value3”
}
}
]
There can be multiple documents being processed and the number of “fields” is more (30+) than the example shows. I have created a Mapper snap to do this work for a few fields but would like not to have to do it for 30+. I feel there is an expression/javascript solution to this but I am not well versed at this time.
Any ideas would be appreciated.
Regards,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2023 11:06 PM
Hi @Thom ,
I’ve attached a pipeline, hope this helps.
Test_Expression_2023_05_31.slp (3.5 KB)
Cheers 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2023 11:06 PM
Hi @Thom ,
I’ve attached a pipeline, hope this helps.
Test_Expression_2023_05_31.slp (3.5 KB)
Cheers 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2023 06:08 AM
Thanks so much. This worked as needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2024 04:19 AM
I'm unable to download the .slp file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2024 08:52 AM - edited 01-10-2024 09:28 AM
The new community platform didn't quite know how to deal with the .slp file extension. Pipelines need to be zipped before uploaded to this community platform.
Let me find it in the backup.
Diane Miller
