Load data only if record not contains nulls

[seWork]

Hi everyone,

Im wondering if there is a shortcut to write a load script that will not load all records that contains at least one null attribute at once 

(Instead of writing all the attributes in the where statement)

[tresesco]

Without writing all attributes! I am not sure; may be someone has an idea. However, a short expression I can think of would be like:

Where Not RangeMin(IsNull(Field1), Isnull(Field2), ...);

[marcus_sommer]

In the case that your source is a crosstable you may to consider to transform it into a "normal" data-structure.

Another approach could be to pre-load your table like: first 1 load * from Source; and then looping over the available fields to create an appropriate where-statement within a variable.

- Marcus