Lookup on an array in the input document
Hello,
I have a incoming JSON document that has cases and array of casesteps inside. I need to do a lookup on the case step code from a table in the database and add additional properties to the ca...
Forum Discussion
Thanks Again, the second json source is given in the post. I have it here again. The join is on the “code” from “casestep” to the “code” in this source. exp_time from second source has to be copied over the main document
[
{
“code”: “abc”,
“exp_time”: “30s”
},
{
“code”: “xyz”,
“exp_time”: “20s”
},
{
“code”: “def”,
“exp_time”: “40s”
}
]
I hope this is what you want.
But without complete requirement and data, I cannot get you complete solution.
Definitely this should be a way forward for you.
Ignatius_cases_2017_08_04.slp (9.0 KB)
Attached is the sample I worked. I am sure you can improve upon.
Thank you, the example is very helpful. Appreciate it!
