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

Identical names not matching

soncoku
9 - Comet

Hey all.
I'm using the Join tool and I'm matching 2 different lists on the name field.

1 input is an excel file

the other input is Google Sheet.

 

The column type for both is V_WString.

 

The strings are identical but they do not match.

Any ideas as to why this is happening?

 

8 REPLIES 8
PhilipMannering
16 - Nebula
16 - Nebula

I think showing an example (or better still sharing example data) would help a lot.

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Use data cleansing tool in order to clean tailgating spaces.

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @soncoku 

 

You are identical, So it not exact 😅

 

Maybe you can data cleansing tool for clearing leading and training spaces. And use find and replace Tool for flexibility.

 

https://help.alteryx.com/current/designer/data-cleansing-tool

https://help.alteryx.com/current/designer/find-replace-tool

 

soncoku
9 - Comet

@Emil_Kos I've done that but it didn't help much. Also modified the case to Title but still.

 

@PhilipMannering can't do that as the data is confidential.

atcodedog05
22 - Nova
22 - Nova

Hi @soncoku 

 

Can you give find and replace tool a Try.

https://help.alteryx.com/current/designer/find-replace-tool

 

Emil_Kos
17 - Castor
17 - Castor

Hi @soncoku,

 

Two steps that I would take: 

 

1. Save both in excel and check if there are identical. 

2. Put them next to each other in Alteryx and use '=' sign in order to see if Alteryx see's them as identical. Exemple formula [Column1]=[Column2]

ehughes
9 - Comet

I would guess that there may leading/trailing spaces that you need to remove, like Emil said. But also, the Join tool is case sensitive so for example, 'SKY' and 'Sky' will not match

grazitti_sapna
17 - Castor

Hi @soncoku,

 

Try and remove the leading and trailing spaces from your data.

 

 

Sapna Gupta
Labels