Data manipulation - Find and Replace

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

Toask_alteryx.xlsx

Datasets

Tips and Tricks

Transformation

Dynamic Processing

Data Investigation

Accepted answers

Zok

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

TrucChelouSaRace2.yxmc

All comments

Zok

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

TrucChelouSaRace.yxmc

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

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

TrucChelouSaRace2.yxmc

sriniprad08

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

Cheers,

Sri

Zok

Happy to help

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335