Search based on one field and replace the values in another field using FindReplace Tool

Team, I have fields as follows:

Input File 1:

Type	Description
HA	Hello

Input File 2:

Type Code	Doc Type
HA 01234	Hello

I would like to use the "FindReplcae" tool and use "HA" from Input file 2 as the Lookup value and find that in Input File 1 and get the Description value as "Hello" in the "Doc Type" field.

Please help, thanks in advance.

Workflow

Input

Tips and Tricks

Join

Preparation

Accepted answers

cjaneczko

New Workflow2.yxmd

OllieClarke

@Rahulkanth
I don't think your sample data is correct. IN and KR appear in the Doc. No., but not in the Doc Type column.

Having said that, the following workflow I believe should work for you.

Instead of the Find and Replace tool, we can just parse out the first 2 characters of Doc.No. using

LEFT([Doc. No.],2)

We can then join based on this and the Doc Type. We can also drop the original Doc Type and rename the Description Field to be Doc Type

Because of the IN and KR numbers, we need to union the Left and Join outputs (dropping the field we created from the Left output), to get our final table

Hope that helps,

Ollie

All comments

OllieClarke

Hi @Rahulkanth

Here is how you'll want to set up the tool

Hope that helps,

Ollie

Rahulkanth

@OllieClarke I already have a column named "Doc Type" where value needs to be replaced into that column.

Also, I have lot many columns with a similar situation. appreciate your help in advance, thank you.

cjaneczko

Can you provide more sample data on what your data looks like and how you want it updated? I came up with the same solution as Ollie based on your inquiry. His solution seems to do what was asked.

Rahulkanth

Hi @cjaneczko, I have the same solution suggested by @OllieClarke to replace/append the field from the other Input file, but my question was to replace/populate the found values in the specified field which is already existing.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703