INDEX(INDEX(oneRowTable[enumListColumn], 1), 1)?

[leinharte]

Hi.

This expression is not working.
INDEX(INDEX(oneRowTable[enumListColumn], 1), 1)

oneRowTable has the enumListColumn. The oneRowTable has only one row and the enumListColumn's type is EnumList. I want to get one value from the list of enumListColumn at another table. And I used the expression, but it is not working.

Could you help me, please.

[Suvrutt_Gurjar · Accepted solution]

Please try

INDEX(SPLIT(oneRowTable[enumListColumn], ","),1) for the first value from the Enumlist.

INDEX(SPLIT(oneRowTable[enumListColumn], ","),2) for the second value from the enumlist and so on.