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?
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?
-
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
Please sign in to leave a comment.
Comments 1