Forum Discussion
map field from other table without having a relation, multiple hits and default value if not found
product | value |
1 | 155 |
2 | 160 |
3 | 170 |
4 | 100 |
product | code |
1 | A |
1 | B |
2 | C |
3 | D |
As you can see. Where product = 1, there are two results and where product = 4 there is not hit.
I would like to have this result:
product | value | code |
1 | 155 | A |
2 | 160 | C |
3 | 170 | D |
4 | 100 | Unknown |
Is it possible to create the code field in the first table within the Query editor?
1 Reply
Hi amien
You can adapt this : Vlookup M Language
If this solves your issues, please mark it as the solution.Patrick
