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.
Hi @Emil_Kos,
Thank you for your reply. The reason find and replace won't work is that I don't need a name replacement itself.
Only in case the Unit ID is are in replacement list do I need the name to be changed.
Find and replace would replace every instance of the name which is not required.
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?
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.