Merge tables full join

1

Hello,

If you use action merge with option full join, on Table A merging B you might want to see empty cell when value doen’t exist in the other table.

A
1
2

B
1
3

I want (X = empty)
AB
11
2X
X3

And the result in EM is

AB
11
2X
33

I don’t understand why value 3 is duplicated.

2

Because A and B in your merge are key fields. A full join produces the union of keys.

To achieve what you want, you need to merge on a key that is not B, or A. A column clone would do it.

full-merge.morph (3.5 KB)

image

1 Like