Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
This worked great. Thanks for all the help!