I am a beginner to Quantrix.
I’ve read many lookup function like select / using as in the website.
However, when I was trying to do something like excel v-lookup. I have no idea at all :
Matrix 1 with category Colour :
Matrix 2 with lookup category:
I type using as / select formula and try to get blue x = 2 and green x = 3; however, both of them do not work.
Anyone could give advice me on this ?
You can use the structural function @item() within the select function to create your key and lookup values as shown below:
Lookup result = select(Source2::Value list, @item(Source2::Key list), @item(Lookup value))
I believe this is what you are looking for as it eliminates the need for hidden keys. See the attached model.