topic Re: LOAD all fields except ..... in QlikView

LOAD all fields except .....

richard_chilvers — Wed, 15 Oct 2014 08:31:52 GMT

It seems good practise to LOAD only those fields in a table which are useful, although the temptation is to LOAD everything, "just in case".

Of course, this can be achieved by listing each field which is required, but I wondered if there is a way to say LOAD all fields except .....

Perhaps LOAD * - NOT_NEEDED1, NOT_NEEDED2 FROM .... ;

alexandros17 — Wed, 15 Oct 2014 08:35:06 GMT

Unfortunately no, just comment out the fields unwanted ...

tresB — Wed, 15 Oct 2014 08:39:55 GMT

Or just use Drop Field after a Load *, like:

Load * From <>;

Drop Fields field1, field2;

Otherwise, if all fields are known, commenting out would a better option.

richard_chilvers — Wed, 15 Oct 2014 08:41:49 GMT

Oh yes, I should've thought of that. Its a pretty good solution.

Thanks