JOIN XML and another input

[dbaltazar]

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.

Appreciate your inputs.

Best regards,
Dorothy

[cstewart · Accepted solution]

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 -
Then it will join on all documents, giving you the output it sounds like you want.

[dbaltazar]

Thank you! This solved the problem.