Find Replace tool

Hi Team

I'm trying to perform Find Replace instead of Join tool from 2 tables. Attached is the workflow which is performing both Join and Find Replace. I'm more concerned about Find Replace as Join is bringing mutliple records because my Table 2 has multiple entries to satisfy.

I have been told that Find Replace works like VLOOKUP in excel.

My main question is why the Find Replace tool is outputting value as 2 for WORK ID 2 Column instead of 1.

In excel, if we perform VLOOKUP it is outputting value as 1 for WORK ID 2 Column.

Thanks
Satish

FindReplace.yxmd

Developer

Accepted answers

ShankerV

Hi @satishkurra

Please be informed that, the logic which is incorrect as

when you use an option of Find and Replace should be unique.

Where we cant have Same Find and Multiple Replace give in Excel find and replace option.

Here Find and Replace tool works the same way, but to find more Find and more Replace at same time.

I can suggest the alternative solution below.

All comments

ShankerV

Hi @satishkurra

Small correction, Join tool only works as VLOOKUP in excel.

Now can you reframe the question please based on the Vlookup function as Join tool in Alteryx.

ShankerV

Hi @satishkurra

I have tweaked the input, added 3 also.

The result is 3.

i.e the last match found relevant value is replaced by Find and Replace tool.

Many thanks

Shanker V

satishkurra

Yes. You are right. It is taking the last record. In below example it is taking 3 after you add 3rd record. How to stop once I find the matching value. In this case 1 is also have a matching value on ST and ST2 columns

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167