Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to exclude/remove a column named ID when I load data from a SQL databas. Since I have so many columns I would prefer to remove this one instead of writing all of the columns I want to load.
Thanks in advance.
/A
Use the drop field statement.
load * from ...;
drop field ID;
Regards,
Florian
There's no way to specify a list of fields to exclude. Let the wizard create the statement for you including a preceding load and the comment out the lines with the columns you don't want. You can comment a line out by putting two slashes at the beginning, i.e. //. If you have a number of consecutive lines you want to comment out then you can select them with the mouse, right click and select Comment.
Use the drop field statement.
load * from ...;
drop field ID;
Regards,
Florian