Find Replace tool

Question

Hi Community,

Here is my existing sample dataset:

IDExclusion SummaryReason of Exclusion (Overall)333333InN/A444444InN/A

I want to update the details in "Exclusion summary" and "Reason of Exclusion (Overall)" to:

IDExclusion SummaryReason of Exclusion (Overall)333333OutManual (TL)444444OutManual (IL)

can you please guide?

Qiu · Answer

@LeoMessi 
I like your ID😁
There are a few ways to update value.
What will be your logic?

FrederikE · Answer

Hey @LeoMessi,

Unless there is any logic behind this that you didn't mention, the best way to solve this is a lookup table. See the attached example.

New Workflow11.yxmd