don't filter null values

[surajap123]

Hi All,

I am using exists() to filter the data from 2nd table. However i don't want to filter out the row if the value is null.

Stock:

LOAD Material

FROM

data.xlsx

(ooxml, embedded labels, table is Stock);

Sales:

LOAD Product,

     Sales

FROM

data.xlsx

(ooxml, embedded labels, table is Sales)

where exists(Material,Product);

Please help.

[daveamz · Accepted solution]

Hi Suraj,

where exists(Material,Product) OR IsNull(Product)

​Regards,

David

[tresesco]

May be like:

....

FROM

data.xlsx

(ooxml, embedded labels, table is Sales)

where exists(Material,Product) OR  IsNull(Product);

[surajap123]

Awesome.:)

Thanks everyone.