fieldvaluecount - script function

This script function returns the number of distinct values in a field. fieldname must be given as a string (for example a quoted literal).

Syntax:  

fieldvaluecount(fieldname)

Example:  

In this example the number of regions is counted and stored in the RegionCount variable. This value, 2 in this case, can then be used for further transformations where you need to know the number of existing regions.

LOAD * INLINE

[ Region, Year, Month, Sales

South, 2014, June, 645

North, 2014, May, 245

North, 2014, May, 347

North, 2014, June, 127

South, 2013, May, 367

South, 2013, July, 221 ];

 

Let RegionCount = FieldValueCount('Region');

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?