Find and replace data

[praneshsapmm]

Hi all,

I have this requirement : 

Input 1 : 

User ID	Invoice
Smith;Alex	12
John;Dev	13
John	14

Input 2 :

Userid	Replacement ID
Smith	Rita
Alex	Robert
John	Suzanne
Dev	David

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

Output : 

UserID	Invoice
Rita;Robert	12
Suzanne;David	13
Suzanne	14

Many thanks .

[IraWatt]

Hey @praneshsapmm,

Here is the setup you want:

[Felipe_Ribeir0]

Hi @praneshsapmm 

One way of doing this:

[IraWatt]

@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