Dynamic Replacement based on a different field

Question

Hi,

I am working on a workflow which requires to overwrite the name of certain Units from their Old names to new names within the input data based on the Unit ID.

The New names of the Unit IDs will be provided as a separate input (mentioned as Replacements to be done below).

Note that the replacement needs to happen on the Unit ID.

I am just unable to figure out the replacement expression.

Input Data:

Replacements to be done:

Target Outcome

Any help would be really appreciated.

Name Replacement Based on Unit ID.yxmd

Emil_Kos · Answer

Hi @PKoya,

I wasn't able to make it using the dynamic rename tool but the find and replace tool should give you the same output.

Apologies if I am missing something obvious but I am not sure what is the difference in your particular example.

Name Replacement Based on Unit ID (1).yxmd

PKoya · Answer

Sure, @Emil_Kos.

I have attached a sample workflow here which should give you more details.

Name Replacement Based on Unit ID.yxmd

Emil_Kos · Answer

Hi @PKoya,

I am not sure if I understand correctly. Do you want to change the name only for the first ID that occurs in the data?

If not could you kindly provide a little bit more details so I will be able to understand your requirement better?