to obtain the count of distinct values in a given field.

[#1]

Hi All,

Is it poosible to obrain the count of distinct values in a given field

for a given table and use that value for specifying limite  in FOR Loop

in load script.

[Gysbert_Wassenaar · Accepted solution]

If the field exists in only that one table then you can use fieldvaluecount:

LET vMyFieldCount = fieldvaluecount('FieldNameHere');

Otherwise you'll have to calculate the count first:

Temp:

load count(distinct FieldNameHere) as MyFieldCount resident MyTableHere;

LET vMyFieldCount = peek('MyFieldCount');

drop table Temp;