Thank you, this is exactly what I was looking for. One question though, if I only want to load columns H-AG, how can I do that? I've tried
and it is not working.
LOAD H:AG also does not work.
Do you know how I can have it load only those columns and not all of them (*)?
If you don't want to load all columns (which you could simplify with the wildcard) you will need to specify each single column - if you used the wizard for the load-statement this won't need much efforts.
To shorten a load-statement you could variables - whereby you will add some complexity and reduce to some degree the readability. But nevertheless you could do:
set vColumns = H, I, J, ....;
load $(vColumns) From YourSource;
Another possibility could be to load all columns with the wildcard and then drop all unwanted columns but this will be only useful if there are much more columns to load then not to load and you will in each case increase the load-times.