Removing Null Value Data Wile Loading as Load *

Satish251 — Tue, 20 Jul 2021 13:38:54 GMT

Hello Everyone,

Hope all of you are safe and in good health.

I would like to know that suppose I have a Data Sheet with 10 Fields (A, B, C, D, E, F, G, H, I, J) (Just an Example) and among those 10 fields suppose Field C & Field H have Null values So when I write the command

Load * , wanted to know the condition to be applied so that the Fields C & H are not loaded itself in the Data Load Editor (Qlik View).

Thanks in Advance.

Regards,

Satish Rathod

Re: Removing Null Value Data Wile Loading as Load *

MayilVahanan — Wed, 21 Jul 2021 08:34:48 GMT

If you want to ignore the field, you can remove from the data model.

Ie. instead of *, mention the field names which need to load in the datamodel like below

Load A, B, D, E, F, G, I, J from urexcelsheet;

topic Re: Removing Null Value Data Wile Loading as Load * in QlikView

Removing Null Value Data Wile Loading as Load *

Re: Removing Null Value Data Wile Loading as Load *