While doing a Join string not matching

[lagos-a1]

Hi, 

While doing a join with two strings the icon "Join" is not matching same values even though the two values are located in both tables. 

For example, deskName 11.04 appears in the result R of the join. However "Name" 11.04 is presented in "Resource Desks.csv" file

Resources - Desks.csv 

Name and DeskName are dataType = V_STRING 

Not sure what is causing the issue as all  Resource desks.csv "Name" fields are in "DeskName" 

[Qiu]

@lagos-a1 
It is working for joining based on my test.

Is it possible you are having leading or trailing white space in the data?

[Raj]

try using a data cleansing tool for specific column

also, check the data type for both of them is the same

if still not working kindly share sample data

[Dina]

I would also recommend double check the data type of those two columns from the input anchor. If they are both v_string as you mentioned, then try to do a v_lookup in excel to see if it works. 

[RobertOdera]

Hi, @lagos-a1 

It's possible you have a trailing or leading space.

Consider adding a formula tool before the join for both incoming inputs and so this TRIM(ToString([Name])) or TRIM(ToString([DeskName])), whichever is applicable.

I hope that will solve it for you - Cheers!