Wrong Output is coming in Joint

[rohit782192]

Hello ,

In my Input  1 i have below

A B C
1 abc def

In my Input 2 i have below.

A B C
1 def abc

I am joining on Primary Key A.

I am getting a weird output.

Can anyone help me.

[rohit782192]

In my Example A is my key column.

[IraWatt]

This is how I would create a key column so that A,B and C must be the same:

[rohit782192]

In your Example A is also going in L and R. It should go to J as they are common in both in my example

Just have a check.

[IraWatt]

Ow I think I get what you want now:

This set up will put the A in the centre join and B and C in the left and right.

[IraWatt]

@rohit782192, you can cross tab it back like this:

[rohit782192]

No.

The Output Expectation is different.

[IraWatt]

@rohit782192 Can you show what you expect out of the left, right and centre eg:

Left:

A	B
1	2

Centre:

C	D
3	4

Right

NULL/Blank

[rohit782192]

A SHOULD BE 1 since it is common in both the input data tool

While Left and R should be fill with B and C column respectively.

[IraWatt]

@rohit782192 How does this differ to the solution I linked:

Left:

Centre:

Right:

[grazitti_sapna]

@rohit782192, is this something you are looking for?

This might not be the best solution but if this is what you are looking for hope it helps!

Thanks!