Data manipulation - Find and Replace

[sriniprad08]

Hi Team,

Hope you are well. I need help and idea how to go about this.

Please find attached the table and also the desired output.

i have a big dataset. The flow has to do search and perform the below thing,

The file has three columns

Objective :Where ever the attribut is present in the dataset it has to create a new variable for e.g. "Document type_
BLART_Desc" and replace the ZX with Clearing xTP. Like that It has to do for all the tables

cheers,

Sri

[Zok]

Not sure I fully understood but I try (you will have to rename the last columns)

[sriniprad08]

Hi @Zok ,

Thank you very much for the help and the time. Really appreciate it. Sorry may be i wasn't clear on this.

1) i have a dataset - Dataset_V1 - It has many columns with the one marked in Green.

2) Matching Table - I have a matching table 

The workflow needs to find the value "marked in Green" and replace the value and create a new column in Dataset_V1 "marked in Red" .

For e.g. Where the value "ZX" is present in Dataset_V1 it has to be replaced with "ClearningxTp" and new column should be created.

[Zok · Accepted solution]

I think you can mix the two answers to make something that will fit

[sriniprad08]

Thank you so much @Zok for your time and effort. Perfect.  

Cheers,

Sri

[Zok]

Happy to help