Hello ,
In my Input 1 i have below
A B C1 abc def
In my Input 2 i have below.
A B C1 def abc
I am joining on Primary Key A.
I am getting a weird output.
Can anyone help me.
Attaching Workflow.
@rohit782192 I dont see any issue in the join. Are you getting like below
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
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
@rohit782192 for that you need to change the join like below
I have joint on primary key . If i have joint on A, B , C then only i get the Expected output,.
They are joining because currently your just joining on A:
You need to do this:
Hello,
This is just a 3 column.
What about if we have 100 or 200 column.
You will joint on all.
@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
In my Example A is my key column.
This is how I would create a key column so that A,B and C must be the same:
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.
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.
@rohit782192, you can cross tab it back like this:
No.
The Output Expectation is different.
@rohit782192 Can you show what you expect out of the left, right and centre eg:
Left:
Centre:
Right
NULL/Blank
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.
@rohit782192 How does this differ to the solution I linked:
Right:
