topic Set field as null on load in QlikView

Set field as null on load

Wed, 25 Nov 2020 16:16:04 GMT

I am loading a table from sql and I am trying to assign a null to a field when loading, for example:

Load field1 as "Field1", null() as "Field2"

From ....

How can I do this in Qlik? I want to set "Field2" to null on load.

swuehl — Mon, 09 Jan 2017 23:20:52 GMT

null() as "Field2"

should work in the LOAD statement of your table load. What do you get instead?

LOAD 1 as NotNull,

Null() as Null

Autogenerate 1;

Maybe you just need to use a

to be able to use QV functions?