Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have aexcel under which there is a column (Field) Product, which has some blank values ,
Now in the script iam writing the below code
match( Product, ='','') as Product, so that the null (Blank values ) showed be suppressed,
But after reloading iam geting 0 ,
My result shoul be like where ever there is blank it should not show anything ,
In the script iam writing the script wrong ? PLease suggest me
Try this instead:
LOAD
If(Len(Trim(Field)) > 0, Field) as Field
Or if you want to handle the null values
you can add this
Set NULLINTERPRET ='';
in the load script
you can use
if(isnull(FieldName) , expression1, expression2)
try like this
if(len(trim(field_name))>0,field_name) as field_name
//if you eliminate the complete data associated with the null values then
LOAD *
from table_name
where len(trim(field_name))>0;