Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if(len(trim(Depot))=0 and len(trim(Factory))=0, 1,0) as DoubleNullFlag
if(len(trim(Depot))=0 and len(trim(Factory))=0, 1,0) as DoubleNullFlag
Hiya
fab, all works thanks Gysbert!!