Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find and Replace not working

sriniprad08
11 - Bolide

Hi Team,

Hope you are well. i am trying for longer and couldnt find a solution.

I need your help

I have two columns i would like to find if List1 is in List 2.

 

There are difference interms of last few letters. I am trying to use find and replace but not sure which options to choose.

sriniprad08_0-1679324263003.png

i tried all the below options. Entire list, part of the list and case insensitve,match whole word only. But not sure what i am missing.

I need a column C which says if List1 is in List2.

sriniprad08_1-1679324277075.png

thanks

8 REPLIES 8
binuacs
20 - Arcturus

@sriniprad08 One way of doing this

binuacs_0-1679324629272.png

 

FrederikE
13 - Pulsar

Hey @sriniprad08,

 

If you only want to check if one cell is in the other cell you don't need a F&R Tool. 

 

You can just go with a "Contains" function. 

 

FrederikE_0-1679325439448.png

 

sriniprad08
11 - Bolide

Hi @binuacs ,

 

Thank you so much. Appreciate that. Is possible to check with numbers if one is present in another?

sriniprad08_0-1679402530981.png

 

sriniprad08
11 - Bolide

hi @FrederikE ,

Thank you for the help. These are coming from two different files. 

is it possible to compare when List1 is from one file and List2 is from another file?

 

 

sriniprad08_0-1679402599437.png

 

ShankerV
17 - Castor

Hi @sriniprad08 

 

Yes, it is possbile.

But you have value as 0 as first value and all the values in dataset contains 0.

 

Hence what is the expected output please.

 

Many thanks

Shanker V

sriniprad08
11 - Bolide

Hi @ShankerV ,

 

Thank you for the reply. Please find below

sriniprad08_0-1679405542109.png

 

binuacs
20 - Arcturus

@sriniprad08 Find and Replace tool works only on the string fields, because of that you need to convert your numerical field into a string first then apply the find and replace tool

 

binuacs_0-1679407273859.png

 

sriniprad08
11 - Bolide

Hi @binuacs ,

 

Appreciate your help. thank you.

 

Cheers,

Sri

Labels