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 fileTargetAdministrator/Transfer agentEntityAdministratorOther role-related entityEntityAssetManagerAuthorized signatoriesIndividualAuthorisedSignatory The list is long, this only a simple. Any advice on how to proceed please? Thanks

Change the data in one column

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

Datasets

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

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

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

Thanks @Jonathan-Sherman , That works fine

Thanks for the help @Assaf_m