Count values different of empty

[#1]

How can I count all values in an excel collumn  different of empty?

Thanks

[erichshiino]

When you load from excel, empty cells will be considered as nulls.

Count(field) should work fine for your case.

Do you have a sample where it doesn't work?

[Miguel_Angel_Baeyens]

Hello Kelly,

Although this will work, in case you know you will find some values in one field empty/null/missing, I'd use  flag for them and sum the number of flags in your records in the expression. In my experience, and depending on the model and the data set, this usually performs better

Script:

Table:
LOAD *
     If(Len(Field) = 0, 1, 0) AS NullFlag
FROM Source;

Expression:

Sum(NullFlag)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica