Hi Community,
I wonder if you can help me with something.
I am working on a large workflow. I am trying to join to different tables (sources) BUT with a conditional join.
As an example, please look at the tables below. "Table 1" contains the value I want to compare, and the "Table 2" contains the value I want to bring into my data. In this case, for instance, for my value "5", the corresponding joined value should be "A", for "7", "9" and "11", should be "B", and so on. As you can see, I need to compare my value in Table 1 with the lower and higher limits in Table 2, to bring the value that matches.
| Table 1 | | Table 2 | | |
| | | | | |
| Value | | Lower value | Hogher value | Target value |
| 5 | | 1 | 6 | A |
| 7 | | 7 | 12 | B |
| 9 | | 13 | 18 | C |
| 11 | | 19 | 24 | D |
| 13 | | 25 | 30 | E |
| 15 | | 31 | 36 | F |
| 17 | | | | |
| 19 | | | | |
| 21 | | | | |
| 23 | | | | |
| 25 | | | | |
| 27 | | | | |
| 29 | | | | |
| 31 | | | | |
| 33 | | | | |
| 35 | | | | |
Do you have any clues about how can I do this in Aleteryx?
I am using In-DB in the most of the cases, so if there is a solution with In-DB tools would be much better, if not that is not a problem.
Thank you very much in advanced.
