Hi, my problem is very well explained in the attached screen short.
How can i achieve these results. Any help?
@Abhi27101990 of course! Sorry about that.
Hi @Abhi27101990 ,
There are a few different ways to do this.
One way is to filter the dataset, rename the columns and then Find/Replace the filtered data set back on to your original data set.
Another way is to join your input table with a list of defined entities to select, rename the columns and then find/replace the values back with the original data set.
Let me know if you have any questions! If this answers your question then please mark this as the accepted solution.
Thank you for your response Kayers. Can you please share with me the workflow file. It would be very helpful and easy for me to understand it from the workflow file.