This content has been marked as final. Show 2 replies
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
|(not isnull(Field3) or|
|not isnull(Field4) or|
|not isnull(Field5) or|
|not isnull(Field6) or|
or any number of other permutations.
Suggestions please. Thanks