topic Load data only if record not contains nulls in App Development

Load data only if record not contains nulls

seWork — Fri, 06 Aug 2021 07:58:37 GMT

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)

Re: Load data only if record not contains nulls

tresB — Fri, 06 Aug 2021 08:48:31 GMT

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), ...);

Re: Load data only if record not contains nulls

marcus_sommer — Fri, 06 Aug 2021 14:41:26 GMT

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