exclude nulls of field from other table in load script

[FilippoValli]

Hi,

I was wondering if it's possible to exclude null values in loadscript using  Where Len(Trim([field])) > 0 

Altough using field from another table.

Thanks.

[Mauritz_SA · Accepted solution]

Hi there

You should be able to do it by either using ApplyMap in the condition for your table (where you pass a field to a mapping table) and evaluate the returned value using isnull or len, etc.

The second option is to perform an inner join on a table and only loading the joining column from the second table, but restricting it to where your field is not null.

Both these options will work. If you are still unsure then you can post a sample of your two tables I can help you with the script.

Regards,

Mauritz