double null flag

[joeybird]

Hiya

I wish to produce a null flag in the data load

this works for 1 column on a record

If(len("Depot"),0, 1) AS NullFlag,

how do I produce a flag for each record if 2 columns in a row are null?

e.g Depot is null and Factory is null

Please help

[Gysbert_Wassenaar · Accepted solution]

if(len(trim(Depot))=0 and len(trim(Factory))=0, 1,0) as DoubleNullFlag

[joeybird]

Hiya

fab, all works thanks Gysbert!!