In a list, how to omit records with same data so only one shows.

[Sachi]

Hello helpful experts,

 

What I have is a list with 1 field

In the example below (hopefully) you can see that the data in this field can double/triple up sometimes and other times there is just one.

 

This is because we have multiple records for the one client, and each record has different data.

All I need is a list of the Clients but obviously with out there being multiples of the same.

 

Below is an example of what I have:

 

Eg.

CLIENTS

3RPP

3RPP

TY4R

H3EJP

H3EJP

H3EJP

 

What I would like is this:

CLIENTS

3RPP

TY4R

H3EJP

 

Help would be really appreciated. Thankyou.

Sachi

[David Head]

Try a script like this:

 

Sort [YourTable::YourField, ascending, no dialog]
Go to Record [First]
Set Variable [$Value, YourTable::YourField]
Go to Record/Request [Next]
Loop
 If [ YourTable::YourField = $Value ]
   Omit Record
 Else
   Set Variable [$Value, YourTable::YourField]
   Go to Record/Request [Next, Exit After Last]
 EndIf
End Loop

[Sachi]

I'm afraid it didn't work. and I checked it over a few times to make sure I got it right.

 

Can I just do a Constrain Found Set or something?

 

From Sachi

[David Head]

So what happened? What was it that was not working?

 

I can post a sample database to show that it works. However, you are not a member so you couldn't get it.

 

Constrain Found Set will not work for this problem.

[Sachi]

oh ok, well I must be doing something wrong when making up the script.

 

The only step I'm not 100% sure about when I write up the script is the:

Set Variable [$value, YourTable: :YourField]

 

When I select specify for this step it asks for a name, value and repetition. Is this right? then it looks like this:

Set Variable [$name: value:]

 

Is that how its supposed to look and what exactly do I put in the name part? Because i can't specify for it.

Do I put the 'YourTable: :YourField' in value or name?

 

I hope this is legible. lol

Sachi

[AHunter3]

YourTable::YourField is the value that you set the variable to.

[David Head]

Set Variable [$value, YourTable: :YourField]

 

When I select specify for this step it asks for a name, value and repetition. Is this right? then it looks like this:

Set Variable [$name: value:]

The 'name' is the name of the variable - enter $value

The 'value' is the name of the field you are de-duplicating. And it will be of the form given. Just click Specify and select the field from the table.

The 'repetition' can be left empty.

 

When in doubt, read the Help about things you don't know how to use. So look up the Set Variable script step in this case. We have to assume that you can help yourself to some extent.

[Sachi]

Thank you, it finally worked!!

Sorry about wasting your time before.

 

Sachi