Display a map from a Field containing multiple values separated by comma.

[EmersonCardenasSachica]

Hi, I have a map with a feature layer and a table (linked CSV)

The feature layer contain coded rooms and categories, example:

201     investigation

202     services

205A    bathroom

, etc

And the table (linked CSV) contain a field with comma separated values for spaces associated to each Lab, example

Lab:  1

rooms: 201,203,206,205A, 

Lab: 2

rooms: 202,204,205, 205A, 207

this table update frequently.

I want to make a dashboard that select laboratories and see their respective rooms in a map calling from this comma separated field..as the Table is linked and change pemanently so i dont want to use geoprocessing or analyrticis .. its possible? how? thanks for your help.

[ChristopherCounsell]

Working this way is possible with 'contains' and filters

https://doc.arcgis.com/en/dashboards/latest/get-started/filter-data.htm

However you need to a fully unique string values. If you have a room '205' and another '205A', any filters looking for 205 in the string would pick up both 205, 205A, and all other combinations e.g. 1205, 2055...

You fix this by making a full unique string e.g. 00205, 0205A, 01205, 02055