Inner join output - how to only include fields that matched in the result

[wonka1234]

Hi,

I am trying to include only the fields that matched in my inner join output..

current output -

Name	Message	Amount	Process	Right_Name	Right_Message	Amt	Result
Tom	cate2	9	process|cate2	Tom	cate2	2	Matched

expected output -

Name	Message	Right_Name	Right_Message	Result
Tom	cate2	Tom	cate2	Matched

as only the "right" fields were matched.

How can I do this dynamically?

[geraldo]

@wonka1234 

Change in macro 1 and 2 inclusion of select tool