Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ...