I want to get some values in the main table (similar to Excel:vlookup) from another table using an expression.
I can't get the desired values using Scripts(datamodel) because the 2 tables (data & matrix, see attached .qvw) are not directly connected:the "Key Fields" in table1 are calculated after running script, based on expressions:
The Expressions (i.e PARETO EFFICIENCY) are something like that:
Re: vLookup as expression (within unconnected tables)
I really didn't understand your problem. Let's think simpler ways. Can you please tell us what your input data set look like and what you want as an output ??? If you understand your requirement then some dummy entries you can provide. Cheers...