Hello!
I have 3 tables and I need to vlookup from the 2 circle and from the 3 hours. The table3 is the first priority. So if I found hours I don't need circle. The last column "time" put not empty rows of columns "Hours" and "Circle"
Table 1
Route | Detail | Route+Point | Hours | Circle | Time |
301 | D1 | 301D1 | 2 | 2 | |
302 | D2 | 302D2 | 3 | 3 | |
303 | D3 | 303D3 | 4 | 4 | |
304 | D4 | 304D4 | 9 | 9 |
Table 2 - Circle
Route | Circle |
301 | 5 |
302 | 6 |
303 | 4 |
Table 3 - Hours
Route+Point | Hours |
301D1 | 2 |
302D2 | 3 |
304D4 | 9 |
Thanks a lot !!!
Solved! Go to Solution.
Well, I think you should take a look at the Join tool and how that tool works, it allows you to perform the lookups you have identified. The only complexity is the logic for finding unmatched records on your first join with table 3. You should look at the L and R output streams for the join tool to identify the records that don't match. Then you can use those to join against the table 2.
The union tool is likely to be useful in this case! Please have a try and explore the tools available, and let us know where you get stuck after you have made an attempt.
Ben