How to filter Null Values in Script

[#1]

Hi All,

Please find the attached excel file.

I need to filter the null values alone in edit script.(Date Not Filled Records in attached excel file).

Kindly help me on this query.

Regards,

Sivasu

[Anonymous · Accepted solution]

Hi!

You can use where IsNull(Date) = true() to bring all the values that the Date are null;

Or where IsNull(Date) = false() to bring the oposite.

Regards,

Gabriel

[JonnyPoole]

As above, this will only bring in the rows of data where Date is not null:

LOAD ItemNo,

     Month,

     Date

FROM

  (ooxml, embedded labels, table is Sheet1)

where not IsNull(Date);