The class function assigns the first parameter to a class interval.
The result is a dual value with a<=x<b as the textual value, where a and b are the upper and lower
limits of the bin, and the lower bound as numeric value.
An arbitrary string that can replace the 'x' in the result text.
offset
A number that can be used as offset from the default starting point of the classification. The default starting point is normally 0.
Scripting examples
Example
Result
class( var,10
) with var = 23
returns
'20<=x<30'
class( var,5,'value'
) with var = 23
returns
'20<= value <25'
class(
var,10,'x',5
) with var = 23
returns
'15<=x<25'
In this example, we load a table containing name and age of people. We want to add a field that classifies each person according to an age group with a ten year interval. The source table looks like this:
Results table
Name
Age
John
25
Karen
42
Yoshi
53
To add the age group classification field, you can add a preceding load statement using the class function. In this example, we load the source table using inline data.
LOAD *,
class(Age, 10, 'age') As Agegroup;
LOAD * INLINE
[ Age, Name
25, John
42, Karen
53, Yoshi];
The resulting data that is loaded looks like this:
Results table
Name
Age
Agegroup
John
25
20 <= age < 30
Karen
42
40 <= age < 50
Yoshi
53
50 <= age < 60
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!
