Hi Experts,
I have a local variable which store list of array, I need to get the col2 value where col1 is "RF",
Kindly help with the expression as when i tried below expression but its not returning the correct value.
localVariable(
local!a: {{col1: "TX", col2: "Gaurav Singh"}, {col1: "Civil", col2: "Gaurav Singh"}, {col1: "RF", col2: "Gaurav Singh"}},
local!RF: index(
index(local!rows,"col2",{}), wherecontains(
tostring( index( local!rows, "col1", {} ) ),
"RF"
), {} )))
Kindly help
Discussion posts and replies are publicly visible
a!localVariables( local!a: { {col1: "TX", col2: "Gaurav Singh"}, {col1: "Civil", col2: "Gaurav Singh"}, {col1: "RF", col2: "Gaurav Singh"} }, /* Get value from local!a at the same index of the value in local!a.col1 */ displayvalue( "RF", local!a.col1, local!a, null ) )