Forum Discussion
@dmiller I am a little closer to solve my problem but to solve it I still have some issue.
So after mapper snap I use sorting snap and later grouping snap and the output from this snap it seems ok.In the last step I use mapper snap with expression “{}.extend(…$group)”.
The structure in output file is ok, but columns LeaveOfAbsenceEventGroup and LeaveRequestEventGroup are null for employee “Adam Grey” and I expected that in this case I also receive values. Could you explein me what I am doing wrong?
This worked perfectly fine. I do have questions though,
1) will this methodology work for multiple tags(arrays)?
2) Adding the second JSON splitter makes it easier, I did provide a small number of columns in the sample but it has lot morefields. If we have to add 100's of fields it becomes tedious. Is there another option or an easier way to do this?- Aleksandar_A2 years agoContributor III
Hello GanguP,
You can try before splitting the tags array, to map it to include all of the parent fields in a Mapper Snap then split it.
And about the first question, I'm not sure if I understand it, so could you please clarify it?
Let me know if this helps.
Regards,
Aleksandar.
You can refer to the attached pipeline below.