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?
@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?
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