Merging output of one document in next
I am working on a pipeline where I am reading data from CSV generator.
I have 2 types of data H line and I line for each one I need to do some mapping, which is fine. the final output I need to sen...
Forum Discussion
Thanks for the input.
Yes H and I are for header and line items.
I have done similar thing where I am routing H and I to different mapper and processing them individually. Once done I did a merge join and getting one H+I and I in 2 documents. I want H+I+I in one document.
/KS
Try doing this. Of course I used all dummy variables but here are the main steps.
- Read Incoming file into 2 parsers
- Read the first one with header H
- Read the second one with I
- Do any Transformations specific to H and I on that specific route
- On the I route, merge all of them into a single array
- Merge join them in the end
- After the join, use JSON splitter on the I and add each individual H item using the “Including Path”
- You can do further massaging of the data after the JSON splitter.
Look at this example.
H and I_2017_08_15.slp (8.5 KB)
I get this error,
/KS
Solved the issue and I can see one header and 2 line items in one document.
Thanks for the help.Can you kindly share the final solution
