hello,
If the Find replace tool finds me a value in a table that has duplicate values and I want to bring me another column associated with that value, which value would bring me the first one found or the last one?, I thought it worked like the vlookup of excel but I have done a test and I see that it brings me the last value found, can anyone confirm it?
For example
Find table |
a |
table2 | . |
a | 10 |
a | 20 |
Result | |
a | 20 |
Thanks.
Solved! Go to Solution.
@AdrianSanchez I'd imagine the tool essentially makes its way down the list of lookup values and replaces them as they go, so during the run, it'll find the a match and append the 10 result, then find the match again and replace it with 20. If you're wanting to replicate a vlookup then you can do this with a join like so - just choose your fields which will contain matching values as the join condition: