Set field as null on load

[#1]

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]

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

Preceding Load

to be able to use QV functions?