Qlik Community

App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
FilippoValli
Contributor III
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 (2)
1 Solution

Accepted Solutions
Mauritz_SA
Partner
Partner

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

View solution in original post

1 Reply
Mauritz_SA
Partner
Partner

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