Change the data in one column

[MH5]

Hello Community, 

I want to transform data in one column using another file that contains the actual data and the target data as in the example below :

Data in the file	Target
Administrator/Transfer agent	EntityAdministrator
Other role-related entity	EntityAssetManager
Authorized signatories	IndividualAuthorisedSignatory

The list is long, this only a simple. 

Any advice on how to proceed please?

Thanks  

[Assaf_m]

you can use the "Find Replace" tool to lookup the values from the other file

[Jonathan-Sherman · Accepted solution]

Hi @MH5,

As @Assaf_m said i would use a find and replace tool which could take your data source, I've mocked up an example for you below:

And replace the fields with a new value:

If this solves your issue please mark the answer as correct, if not let me know! I've attached a workflow for you to download if needed.

Regards,

Jonathan

[MH5]

Thanks @Jonathan-Sherman , That works fine 

[MH5]

Thanks for the help @Assaf_m