Discussion Board for collaboration on QlikView Scripting.
I have a table which has 7 fields and it is getting additional rows where the first field is filled but the fields 2-6 are blank.
I need to load (resident) ONLY the rows where any one of fields 2-6 are are complete.
I have tried (and had no success) with "LOAD * Resident CSRelated ...
where not isnull(Field1) and
or any number of other permutations.
Suggestions please. Thanks
You can use like below.
LOAD * Resident CSRelated
where not isnull(Prod_INSTANCE_ID)
Drop table CSRelated;
You could try to check against LEN(TRIM(FIELD)) instead of NOT ISNULL(FIELD), but as far as I interpret your screen shot, that should not perform differently here.
Besides that, take care to do a NOCONCATENATE LOAD when you do a LOAD * RESIDENT ..., to avoid auto-concatenation of records.