Jump to content

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

This topic is 6092 days old. Please don't post here. Open a new topic instead.

Recommended Posts


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:







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,


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

Link to comment
Share on other sites

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.


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

Link to comment
Share on other sites

This topic is 6092 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.