LOAD all fields except .....

[richard_chilvers]

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]

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

[tresB · Accepted solution]

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]

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

Thanks