Look the Same But not Showing Match

Hi,

I have this code number for example IAS 7897. I am trying to locate a match by using the join tool but it seems off. I can't understand why it is not showing match considering they look the same.

Can someone to please help me determine why they are not match and make them match. I have attached sample data for your reference.

Thanks and hope to hear from someone.

Kamen

Field1.xlsx

Field2.xlsx

Workflow

Reporting

Regex

Output

Join

Accepted answers

binu_acs

@KamenRider Using a select tool convert your data type from V_WString to V_String then you will see the extra character which was preventing the join to match

join_17082024.yxmd

All comments

shancmiralles

hi! try using a data cleansing tool first...
spaces may be factor that is why they are not matching..

choose
"leading trailing whitespaces" and " tabs, line breaks, and duplicate whitespace" for both files..

@KamenRider

Bren_Spill2

@KamenRider - the example you provided matched up for me no problem. Can you provide a larger sample?

KamenRider

Hi @Bren_Spill2 @shancmiralles

Have you tried running it with Alteryx? It does not match with me. I have tried using the cleaning tool and it is not working. Actually my only problem for this record is the IAS 7897. I am not sure why. Please help me on this. Added more records attached.

not showing.PNG

Looking forward for your response.

Kamen

Field1.xlsx

Field2.xlsx

alexnajm

Somehow there is an extra character @KamenRider - Find Replace would work then

Look the Same But not Showing Match.yxzp

binu_acs

@KamenRider Using a select tool convert your data type from V_WString to V_String then you will see the extra character which was preventing the join to match

join_17082024.yxmd

KamenRider

Thank you so much @binu_acs , You solved my problems. Now I can easily compare them as match or mismatch. Another learning from changing the data types from V_Wstring to V_String. Thanks. :-)

Kamen

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703