Script - check data

lucarizziero — Wed, 20 Apr 2011 17:56:11 GMT

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 — Wed, 20 Apr 2011 18:07:46 GMT

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 ...

topic Script - check data in QlikView