Merge Join

CloverDX Platform
1

I am trying to accomplish this and not sure if it is possible using Merge Joint:

table A
emplid, gender
10001, M
10002, F

table B
emplid, visa
10001, A
10001, B
10001, C

table C
emplid, passport
10002, USA
10003, GBR
10003, USA

I need to merge the tables above to come up with the following one:
emplid, gender, visa, passport
10001, M, A, null
10001, null, B, null
10001, null, C, null
10002, F, null, USA
10003, null, null, GBR
10003, null, null, USA

Is this possible?

2

Hi,

I think this is possible. I am not sure why you have null values instead of “M” on the line nr. 2 and 3 of the result, I think the proper merge operation should return “M” values there. If there is any reason I do not see, filter the values after ExtMergeJoin component, please.

Here is the example graph:
merge.zip