Macro help - right join

[wonka1234]

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!

[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. 

[acarter881]

Hello, @wonka1234.

The "Amt" field is coming from the #1 input to the Union. If you deselect the field prior to the Union, you will not see that field.

[wonka1234]

@acarter881 but i dont know which field it will be... its need to be dynamic

[wonka1234]

@cjaneczko @lbardoe  needs to be dynamic. May not be amt

[wonka1234]

why isnt "amt" coming as "right_amt"? something wrong with the macro.. cant figure it out.

[lbardoe]

The tool adds the word Right to highlight that its the Amt field from the Right Input channel.