How to compare values from two columns but not exact, any part of field

[wonka1234]

Hi,

Im trying to do a find and replace type of comparison between 2 fields within the same dataset.

It kind of gets confusing when I use it on the same dataset as it creates duplicate column names.

Any way you guys do this?

[anandakrishnan]

@wonka1234 Can you share an example of what your trying to do. Share some input and desired images or file.

[wonka1234]

@anandakrishnan 

I want to compare these 2 columns, but doesnt have to be exact

Number	Number2
9085014139	5014139
1122591793	2259179
1122361817	2236181
9999999999	9999999

[caltang]

A formula tool will do if you just want to know if there’s a difference and by how much. Does that help?

[AndrewDMerrill]

If you are trying to match them together, you could use the Contains function

Contains(ToString([Number]),ToString([Number2]))

[wonka1234]

@AndrewDMerrill 

So I get 0 and -1 .. how can i adjust this?

Please see attached workbook.

Expected output - 

Name	Cust_No	ID	NUM	Right_Name	Right_Cust_No	Nmmber
Louis	55555	License	56575	Louis	55555	6575
Louis	55555	Passport	US12345	Louis	55555	US123
Louis	55555	License	1234	Louis	55555	1234
Louis	55555	Passport	CA12345	Louis	55555	1234
Louis	55555	Passport	US12345	Louis	55555	1234

[AndrewDMerrill]

For clarity's sake, I will link to your other thread, where I already posted what I believe to be the solution to your problem:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Compare-2-columns-from-same-da...