cancel
Showing results for 
Search instead for 
Did you mean: 

JOIN XML and another input

dbaltazar
New Contributor

Hi,

I’m trying to combine 2 streams 1 coming from XML parser (or mapper) and another a session Id returned by another pipeline. There’s only 1 session Id and a lot of records from the XML and I need to map this 1 session Id to all of the records. When I used Union, it created another record for the session Id so I tried Join. Merge assigned the session Id to the first record only.

image
image

Appreciate your inputs.

Best regards,
Dorothy

1 ACCEPTED SOLUTION

cstewart
Former Employee

If you want to join the document on the right (result of Call Login Pipeline) with every document on the left (CreateMIs…) then use an inner join with an explicit key - 31
Then it will join on all documents, giving you the output it sounds like you want.

View solution in original post

2 REPLIES 2

cstewart
Former Employee

If you want to join the document on the right (result of Call Login Pipeline) with every document on the left (CreateMIs…) then use an inner join with an explicit key - 31
Then it will join on all documents, giving you the output it sounds like you want.

Thank you! This solved the problem.