there are several csv-files which I have to put in a database via sqlloader. The files look like this:
nr, value,description
839, 73, mydescription
842, 12, mydescription
But some lines in these files are optional and for these specific lines (839, 842) I have to put "null" in the corresponding field of the database if they do not exist in the file. (if they exist use the values and if not insert null)
Is it possible to specify this in the control file?
Thanks, Michael