How to get the label column of the related table from the ID list of the Enumlist

K5
Bronze 5
Bronze 5

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 Solved
1 2 278
1 ACCEPTED 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])

View solution in original post

2 REPLIES 2

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])

K5
Bronze 5
Bronze 5

Tnank you so much!

Top Labels in this Space