Jump to content

How to omit duplicates and show only unique values in a portal


bluearrow
 Share

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

Recommended Posts

Hi,

I have a table with 3 fields:

Field1: Key

Field2: Color

Field3: Maker

There are some records that share the same color. There are some records that share the same maker. The same could be true for any other values in field2.

I would like a portal to show only unique values for field2.

Any ideas?

Thanks in advance

VL_duplicates.zip

Link to comment
Share on other sites

It's a little difficult to explain, but you can see in the attached file. You have to create a calculation field to produce the unique Serail ID of the line item when your criteria are met; Maker and Color in this case. It is an unstored field; so you cannot target it directly from Maker. You can however create another table occurrence of the line items table, and target the stored serial ID using this field.

So the portal for unique values goes thru the 1st child TO to the 2nd. It's a little difficult to see in the Relationship graph, as the lines cross over.

UniqueColors.fp7.zip

Link to comment
Share on other sites

This topic is 5772 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
 Share

×
×
  • Create New...

Important Information

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