Distinct help

[Anonymous]

Hi,

I need get some suggestions on the Distinct values for the 2 Fields in the script level.

Attache are the sample apps.

[rubenmarin]

Hi John, to store in a variable different combined values you can add this script:

Distinct:

NoConcatenate

LOAD distinct Longitude,

     Latitude

Resident AA;

LET vDistinct = NoOfRows('Distinct');

DROP Table Distinct;

For a field you can use:

LET vDistinctLatitute = FieldValueCount('Latitude');