I am looking for a way to combine several fields I imported from an excel sheet. Each row has a unique number and 3 options with text. I want to be able to click on one selection field and make it search through all three of them. At the same time I want to maintain the ability to have the separate also.
The option sometimes was in a delimitted format: Category A or Category C
-> i used subfield to turn it into components and associate both categories to the record
The table had Year and Mission as well so i created a compound key to filter the combination of #,Year, and MIssion by category... not just #. Let me know if you need to change that.
There was a typo in your load script on the first tab. One of hte loads loaded a field named 'misson' instead of 'mission' creating a duplicate table in your data model. unneeded (i think).
.png "Former Employee"){kind=icon}