Distinct help

Anonymous — Wed, 01 Apr 2015 11:42:57 GMT

Hi,

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

Attache are the sample apps.

Re: Distinct help

rubenmarin — Wed, 01 Apr 2015 11:54:00 GMT

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');