Get field value from unrelated table

[Anonymous]

Hi all.

I need to get field value from unrelated table by another field value in this table .

For example, we have table:

A     B

----------

KPI1    55

KPI2    100

KPI3     55

KPI4     99

How can i get the value (col B) for KPI3? Is it possible?

FieldValue(A, 3) solution is not good, because there are duplicated values in B column.

I'd appreciate any help.

[jonathandienst · Accepted solution]

=Only({<A = {'KPI3'}>} B)

[#3]

Use the Expression in Text Object                          =Only({<A = {'$(vSelect)'}>} B)

you have to create a variable and assign                 Getfieldselection(A)

[Anonymous]

Thank you, Jonathan, that's what helpfull!

[Anonymous]

Sorry, could explain how to check only result existense additionally?