exclude nulls of field from other table in load script

FilippoValli — Sat, 16 Nov 2024 05:45:36 GMT

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.

Re: exclude nulls of field from other table in load script

Mauritz_SA — Thu, 23 May 2019 17:59:53 GMT

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

topic exclude nulls of field from other table in load script in App Development

exclude nulls of field from other table in load script

Re: exclude nulls of field from other table in load script