Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
FilippoValli
New Contributor III

exclude nulls of field from other table in load script

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.

Labels (3)
1 Solution

Accepted Solutions
Mauritz_SA
Contributor III

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

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

1 Reply
Mauritz_SA
Contributor III

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

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