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.
Solved! Go to 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