There are two tables.
The first table has an ID column and a name column, and the second table has an Enumlist column with a REF reference to the ID column of the first table.
I want to get the data of the name column of the row of IDs obtained by Enumlist in the second table.
I tried to write an expression like this, but it gives me an error
any(
select(
1stTable[NAME],.
[ID]=[_THISROW]. [Enumlist_Column],.
)
)
<Error>
Cannot compare Text with List in([ID] = [_THISROW]. [Enumlist_Column])
When there are multiple values of Enumlist, what expression should I write to get the value associated with each one from the relation table?
Any advice would be appreciated.
Solved! Go to Solution.
Lazy option, probably wont work, put [ID] inside a list, List([ID]), better option, you could use CONTAIN to check if the ID string is in the EnumList, CONTAIN([_THISROW].[Enumlist_Column],[ID])
Lazy option, probably wont work, put [ID] inside a list, List([ID]), better option, you could use CONTAIN to check if the ID string is in the EnumList, CONTAIN([_THISROW].[Enumlist_Column],[ID])
Tnank you so much!
User | Count |
---|---|
15 | |
15 | |
8 | |
7 | |
4 |