I'm trying to do a Vlookup in Alteryx but the problem is that the value that is being matched can be in either one of col G or col H. The values to be populated is in column I.
My excel function looks like this: vlookup(A1,$G:$I,3,FALSE)
I'm trying to do this using join but I can only join on either G or H. If the data is in the other one, it is missed out. How to solve this?
EG: I'm looking for "AMR"
| G | H | I | J (output required) |
| AMR | US | 240 | 240 |
| CAN | AMR | 233 | 233 |
| BRZ | BR | 432 | #NA |
| TRK | TR | 123 | #NA |
PS: hard-coding to look for AMR won't work because I've to look for 20-30 such strings like AMR
