Combining Several Fields

[#1]

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.

Thanks

~Norman Rea

[JonnyPoole · Accepted solution]

i found three things:

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).

Take a look at the attached

[#3]

This worked great.  Thanks for all the help!