Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronrums
Contributor II
Contributor II

Is it possible for a Dynamic type output to allow null values

I am using a Dynamic type output as the single schema field for a SQL Server tDBOutput column.

I have noticed that if a null value comes in from the query, that column is not added to the dynamic output, almost as if it is ignored.

Is it possible to avoid this? I know that I can default the values using ISNULL or COALESCE in SQL, but I would like to avoid this because we may want to know when the value from the source is actually null.

Thank you kindly!

Aaron

Labels (2)
2 Replies
Anonymous
Not applicable

@Aaron Rumley​ , I think we need to check what's the real value is read from the source using Dynamic schema if a null value comes from the source. To access the column properties and get the column value, please refer to this KB article.

 

 

aaronrums
Contributor II
Contributor II
Author

thanks, that's a helpful article to start with.