Hey so I have been trying to solve this problem for days now and I can't find a solution yet.
So I have the following tables and columns
tableA[column1] - key
tableA[column2] - non labeled column
tableB[column1] - Enumlist Ref
tableB[column2] - I want to Autocompute the list of tableA[Column2] (this is currently config as Enumlist base List)
So my initial though was like this:
SELECT(tableA[column2],IN([_THISROW].[column1]=tableA[column1])
however this doesn't work and I understand because the IN expression allows to search 1 text within a list, so what I would like to know is how to retrieve a new list based on another list.
Appreciate you all for the support
Solved! Go to Solution.
Maybe this one?
SELECT(Table A[column2], IN([column1], [_THISROW].[column1]))
Maybe this one?
SELECT(Table A[column2], IN([column1], [_THISROW].[column1]))
This was so simple that I feel dumb now, thank you so much @chansol
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |