Script - check data

[lucarizziero]

Hi,

In the Load Script I need to check if a field contains values.

For instance:

qv_table:

LOAD data .....

....

then I need to check if the field data contains values - something like:

IF count(data)>0 then

.....

Thanks

[erichshiino]

You can use len() - returns the number of characters or isnull() - returns true if the field is empty.

Load data, if( len(data)=0, 1,0) as emptyFlag ...