Extract data from existing table based on condition & adding the results in the same table

[Abhi27101990]

Hi, my problem is very well explained in the attached screen short.

How can i achieve these results. Any help?

[kelsey_kincaid]

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.

[Abhi27101990]

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. 

[kelsey_kincaid · Accepted solution]

@Abhi27101990 of course! Sorry about that.

[Abhi27101990]

Thank you very much Kayers. Your workflow file is so easy to understand and was very helpful for me. Many many thanks