"Disjunctive union" or "Symmetric difference" of two input sets

Highlighted
Seven Stars

"Disjunctive union" or "Symmetric difference" of two input sets

Hi, is there a way to accomplish this with two input sets, e.g. a main and a lookup to a tMap?

 

Basically, I have two input sets, A and B, that I want to inner join on a single key.  I want two output to sets: one with the elements of A that are not in B, let's call this C, and one with the elements of B that are not in A, let's call this D.

 

I used a tMap and created two outputs, both with "Catch lookup inner joint reject" set to true.  The expression in each output specifies that the key from the other data set has to be null.  In this example A is the main, B is the lookup.  Only the C set was created correctly, e.g. the one that contains the main rows that are not in the lookup.  The D set was never created.

 

I suspect that this cannot be done with a single tMap, but I was hoping to do it with just one.

 

I think I can do it with two tMaps.  I would use a tReplicate to clone each data set and put set A as main and B as lookup into one tMap to generate C and B as main and A as lookup in another to generate D.

 

Thanks for any input.

 

 

--
Please give Kudos and mark topics as solved where appropriate.
Moderator

Re: "Disjunctive union" or "Symmetric difference" of two input sets

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download