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]

Attaching Workflow.

[binu_acs]

@rohit782192 I dont see any issue in the join. Are you getting like below

[IraWatt]

Hey @rohit782192,

The reason why you have the 'right' columns is because they are named identically in both left and right inputs so they have been prefixed with 'right'

If you want to remove them untick them in the join tool.

Any questions or issues please ask :)
HTH!
Ira

[rohit782192]

if both the cell B and C are not equal then why they are going in J . Expectation is they should go in L and R

[binu_acs]

@rohit782192 for that you need to change the join like below

[rohit782192]

I have joint on primary key . If i have joint on A, B , C then only i get the Expected output,.

[IraWatt]

They are joining because currently your just joining on A:

You need to do this:

[rohit782192]

Hello,

This is just a 3 column.

What about if we have 100 or 200 column.

You will joint on all.

[IraWatt]

@rohit782192 If you had 200 columns and you need to join on all 200 you should create a key column and then just join on that one key column