Need help to filter rows using slice

gaixixon · 05-29-2019 10:53 PM

I have two tables.
Table one name “Data”, with a column named “Status”. Column Status have few values such as “Open”, “Close”, “Pending”.
Table two name “Filter” with a column named “Filter.key” and a column named “Filter.value”.
The value of column “Filter.value” is enumlist in this data format “Open , Pending , ElseValue”.
I can retrieve the data in “Filter.value” column by this expression
LOOKUP ("search.value", "Filter", "Filter.key", "Filter.value")
and I believe that the return value is text in this format “Open , Close , ElseValue”

Using Slice, I can list all rows in table Data with Status: Open, Pending as below:
IN ([Status] , LIST("Open","Pending"))

but I am unable to archive what i want with following expression:
IN ([Status] , LOOKUP ("search.value", "Filter", "Filter.key", "Filter.value"))
or this
IN ([Status] , SPLIT(LOOKUP ("search.value", "Filter", "Filter.key", "Filter.value"), " , ")

What should I do in this case?

Steve

The first argument to LOOKUP() should be the value you want to find as an expression. Your examples suggest you may be trying to supply the name of a column as a quoted string ("search.value"), which won’t work. If search.value is the name of a column, try LOOKUP([_THISROW].[search.value], "Filter", "Filter.key", "Filter.value").