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
Do H and I refer to Header and Line data?
Do you only have one H and multiple I lines?
If so, copy the incoming stream and process them independently and merge join them after you are done processing.
Hope it makes sense.
Let us know if this is not what is expected.
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.
