Evaluate content of several fields to determine if unique/duplicate data is in other fields.

[Baylah]

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!

[The Shadow]

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.