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?
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")
.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |