Dereference a list in another table.

[Tragertt]

I have a calendar that has an enumlist field that pulls the values from another field in a different table which is also an enumlist. There is no reference between the 2 tables, I just want to pull the values from the other field. My code looks like this

select(Directory[Organizations],TRUE)

Its pulling the list from the field but it is not giving me the unique values from that list, just the lines of the values. So basically I want to do this if it is possible. Pull the values for my enumlist from the other table enumlist but give me one line for each unique value from the other list

The data displays like this when opening the enumlist field

All Organization, Corona Branch, Sales Team, Management

I Want it to be like this

All Organization

Corona Branch

Sales Team

Management

1 item for each unique entry

I have tried this method https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/List-from-a-selected-enumlist-values/m-p/301812... but it returns nothing. Any help would be appreciated.

[Aurelien · Accepted solution]

Hi @Tragertt 

---

@Tragertt wrote:

My code looks like this

select(Directory[Organizations],TRUE)

Its pulling the list from the field but it is not giving me the unique values from that list, just the lines of the values.

---

if you wish the unique values, you can use UNIQUE() expression.

---

@Tragertt wrote:

The data displays like this when opening the enumlist field

All Organization, Corona Branch, Sales Team, Management

I Want it to be like this

All Organization

Corona Branch

Sales Team

Management

1 item for each unique entry

---

You are probably using a "list of lists". I'm not sure I'm getting it right, but I would suggest to use this expression for example:

SPLIT(CONCATENATE(SELECT(...), " , "))

If that doesn't fix it, can you please share screenshots to illustrate your situation.

 For reference:

SPLIT() - AppSheet Help

CONCATENATE() - AppSheet Help

[Tragertt]

Split worked perfectly, I now pull the list of unique values from the other field. Thank you!