Removing Null Value Data Wile Loading as Load *

[Satish251]

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

[MayilVahanan]

Hi

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;