Join with Same fields in L and R data set

[SouravKayal]

So i have two data sets that I am joining based on a common ID, i have a few same columns in both data sets that i wanted to group under the same name after the join. I will not be able to rename the column with the same name. How can we do that?

[Qiu]

@SouravKayal 
Can you provide a sample input and desired output?

Or maybe you can use the commonn ID and other same fields as Keys for Joining?

[Matt_Hinkle]

Hi SouravKayal - If I'm reading your question right I think you'll want to use the Find Replace tool and then append the fields that you want to include in your data set. I've included a basic example of how that would look in the attached workflow. If you can/want to provide your data set I can help you further.

Thanks,

Matt