Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .... ;
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.
Unfortunately no, just comment out the fields unwanted ...
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.
Oh yes, I should've thought of that. Its a pretty good solution.
Thanks