How to Split a Row into Multiple Rows
Please help to split a Row/Document into multiple Rows/Documents.
If my JSON Input Looks like below in the mapper Snap and I need to split this into multiple documents as shown in the OUPUT
[
{...
Forum Discussion
Hi. See the attached pipeline:
Community7305_2020_05_08.slp (5.1 KB)
The crux is using an expression like the following. Note that in the filter and first map callback, you can use any of the key prefixes that have numeric suffixes: “Student_ID”, “Student_Name”, or “Age”; I chose “Age” since it’s short.
$.keys()
.filter(k => k.startsWith("Age"))
.map(k => k.substring("Age".length))
.map(i => {"Student_ID": $.get("Student_ID"+i),
"Student_Name": $.get("Student_Name"+i),
"Age": $.get("Age"+i)})
