Qlik Community

Qlik Sense App Development

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

joost_potting
New Contributor

Reload column if all values return Null

Hi all,

I'm currently running into the following issue.

To connect to a database I have to use a custom ODBC driver. Unfortunately, there is some bug which gives unexpected results.

Sometimes a column only returns NULL values while there is certainly data there. At the moment there is no possibility to research the driver in detail.

I am thinking of a loop which goes over all columns of a table, and if all values are NULL, reloads that data.

I do not have a clear idea of how to tackle this, but is probably something like this:

  • Initial load all tables
  • Loop over tables, and store those fields which only have null values (via max(len(FieldName)))
  • Reload all those fields and join them to the original tables

Do you guys have any tips on how to proceed?

Tags (3)
Community Browser