Get value into variable based on condition

[#1]

I have table as below-

    Tab2:

ID, Description
1, India
2, China
3, USA
4, NY
5, NJ
6, SA

In my variable I want to move particular value.

E.g.

Variable1 = Description where ID = 5.

Variable1 will have value of 'NJ'.

[#2]

Can any body help on this?

[ashfaq_haseeb · Accepted solution]

Try with this definition

=only({<ID={5}>}Description)

Regards

ASHFAQ

[alex_millan]

Don't know how to do it in the script but,

Would it be suitable to pass the value after scripting just defining in the variable overview panel?

To define it, would be like this:

=Only({$<ID = {"4"}>} Description)

Hope it helps. Find attached an example.

Regards,

[#5]

Hi Ashfaq,

Thanks for reply.

[#6]

Thanks Alex.