Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?