Hi,

I'm not sure if this is the right forum to post this question so if it needs to be re-directed please let me know the right place.

I have a database with 20 fields that contain "color" Information. They look like this basically:

# Color

1. White

2. Blue

3. white

4. green

5. yellow

6. white

7. green

8. brown

9. white

10. orange

11. and so on, etc.....

What I am wondering is if there is a way to evaluate these fields and performa a calculation to determine how many "UNIQUE" colors are represented. In the example above the result I am looking for would be 6 because the White is repeated 4 times and the Green is repeated twice. The Unique colors equal:

White

blue

green

yellow

brown

orange

I don't have a clue how to extract this information and it is important to know for the project I am working on where I must try and evaluate for this information across several thousand records.

Any help would be appreciated.

Thank you,

Steve

PS I'm pretty sure I've never asked this one before!

You can use filterValues() to eliminate duplicate values.

To use it:

  - Create a valuelist or global field with all unique colors, one per line.

  - Append all the fields togather into one piece of text, newline seperated (¶) so they are also one per line.

Call:

  FilterValues( uniqueList; duplicateList ) to obtain a list of unique color values, then use ValueCount() to count it.