Eliminating duplicated/repeatng values

The problem:

You have repeated values in your Publishing Style Sheet, and you only want each value to appear once.

A typical example would be where you are sorting a list of association members first by city and then, under each city, by company name. You only want each city to appear once.

There are two ways to achieve this:

Unique Group Entry

  1. Open up the Element that contains the repeating value field ("city", in this example)
  2. Go to the Preferences tab
  3. Select the Unique Group Entry checkbox
  4. Save the Element
  5. Important! For this to work, you must make sure that the data is sorted on this field.

"Do Not Include" option in Formulas

Another way to achieve this is to use the Do not include if element data is the same as previous option in a Formula. This can be useful when you are using a Formula to decide what data to publish or when you simply want to eliminate duplicates without actually sorting on that field.

  1. Create a new Element and select the Formula option
  2. Set up your Formula to determine what data to publish
  3. Select the Do not include if element data is the same as previous checkbox at the bottom of the window.
  4. Save the Formula

As each record is published, CatBase will evaluate the contents of that Element and compare them to the same Element in the previous record. If they are the same, the second instance will not be published.

Go to CatBase.com