Find and replace data

Question

Hi all,

I have this requirement :

Input 1 :

User IDInvoiceSmith;Alex12John;Dev13John14

Input 2 :

Userid Replacement IDSmith RitaAlexRobertJohnSuzanneDevDavid

User ID must be replaced with replacement ID and generate output as show below :

Output :

UserID Invoice Rita;Robert12Suzanne;David13Suzanne14

Many thanks .

IraWatt · Answer

@praneshsapmm sadly their ant any interactive community lessons I know of on the find and replace tool, but the docs are here for some contexts Find Replace Tool | Alteryx Help

Felipe_Ribeir0 · Answer

Hi @praneshsapmm

One way of doing this:

Find and replace data.yxmd

IraWatt · Answer

Hey @praneshsapmm,

Here is the setup you want:

Workflow.yxmd