Condition for Advanced Join tool using numeric formulas

[nd2]

Hello, 

Let's say I have two datasets: 

FILE 1
Name	Price1
A	11.4
B	43.1
C	100.2
D	24.2

FILE 2
Name	Price2
W	100.2
X	24.2
Y	11.4
Z	43.2

I want to join IF the values match or are +/- 1 from each other. So A should match with Y, B to Z, C to W, and D to X. Now the problem is that if the Join tool will join by specific fields, and I choose price on the left and price on the right, B and Z will not match because 43.1 and 43.2 will not match with each other.

I tried to leverage the Advanced Join tool here with the condition being: "Price1" >= "Price2 - 1" && "Price1" <= "Price2 + 1". This does not give me any results. I'm not sure if this is because of the numbers within the condition, or I'm not setting the condition correctly. 

I have been trying to figure this out for hours and would appreciate some help. 

[fmvizcaino · Accepted solution]

Hi @nd2 ,

I'm sharing you a solution where you combine all the possible matches and then evaluates with a filter tool.

Example attached as well.

Best,

Fernando Vizcaino