Hi, why am I not having "Amt" appended with the word "Right" here? I am getting confused. inner join output - NameMessageAmountProcessRight_NameRight_MessageAmtRight_AmtResultLouisCate 2-5process|Cate 2 Data 1 Unmatched in Data 2LouisCate14process|Cate1 Data 1 Unmatched in Data 2Stevecate510process|Cate5 Data 1 Unmatched in Data 2Irenecate615process|Cate6 Data 1 Unmatched in Data 2Alancate1-7process|cate1 Data 1 Unmatched in Data 2Tomcate29process|cate2 Data 1 Unmatched in Data 2 LouisCate2 1Data 2 Unmatched in Data 1 Alancate1 2Data 2 Unmatched in Data 1 Rencate2 2Data 2 Unmatched in Data 1 im trying to make this output more readable. It doesnt really make sense for there to be a "amt" + 'right_amt'? From the inner join output I do have right_name and right_process, but just "amt" ? please help! macro join isuse.yxzp

Macro help - right join

Hi,

why am I not having "Amt" appended with the word "Right" here? I am getting confused.

inner join output -

Name	Message	Amount	Process	Right_Name	Right_Message	Amt	Right_Amt	Result
Louis	Cate 2-	5	process\|Cate 2					Data 1 Unmatched in Data 2
Louis	Cate1	4	process\|Cate1					Data 1 Unmatched in Data 2
Steve	cate5	10	process\|Cate5					Data 1 Unmatched in Data 2
Irene	cate6	15	process\|Cate6					Data 1 Unmatched in Data 2
Alan	cate1-	7	process\|cate1					Data 1 Unmatched in Data 2
Tom	cate2	9	process\|cate2					Data 1 Unmatched in Data 2
				Louis	Cate2		1	Data 2 Unmatched in Data 1
				Alan	cate1		2	Data 2 Unmatched in Data 1
				Ren	cate2		2	Data 2 Unmatched in Data 1

im trying to make this output more readable. It doesnt really make sense for there to be a "amt" + 'right_amt'?

From the inner join output I do have right_name and right_process, but just "amt" ?

please help!

macro join isuse.yxzp

Custom Tools

Accepted answers

All comments

lbardoe

You must have Amt in both the Left and Right Data Sources. On the Join join you can untick the one you dont want and rename the other one to a different name or remove the Right from the name.

cjaneczko

The union tool is bringing in every field name from Left, Join and Right. If you want to consolidate the Right_Amt into Amt, uncheck the Amt in the Dynamic rename tool.