Hi all,
I'm building an Experience using data that starts in Excel and goes from XLSX > CSV > Pro (CSV to XYTabletoPoint to geodatabase) > Online > EB (so that I can add attachments and edit the pop-ups).
Each row represents a location/point on the map, and each column/field is an attribute (type of location, date created, whether it still exists, etc.).
The issue is with attributes that need to hold multiple values for a single location. For example, one attribute is political affiliation (this is unrelated to the US). A single location has multiple affiliations, plus their abbreviations. Initially, I wanted abbreviations to be filterable values on their own while also linked to their full names, so that filtering one would also return the other, but I couldn't get that working. For now, I've just put the abbreviations in parentheses. Off the top of my head, here's what one location might have in that field: National Party of Calico Cats (NPCC), Paws Raise Up (PRU), Cats United (CU).
I've tried separating the values in Excel with semicolons, commas, etc., but once I get to the filter widget in EB, it recognizes the entire list/text/string of each location as one filterable value. Instead, I'd like each affiliation/abbreviation of each location to be filterable. And do so for the other attributes that have more than one value in them.
I know I can create one column for every separate value, but then they aren’t filterable under the same attribute (I think?).
Is there a way to structure the data at any point in the process so that one attribute can store multiple values such that each value can be filtered individually? Or something in the filter widget that can get this done?
Edit, to clarify, filterable using the "is any of" option. So that one can select multiple values per attribute.
Thanks!
