Text Importer - Add timestamp

[jcharlto]

I'm trying to import a text file and would like to add a date field that I can fill with the sysdate. Is there a way to do this with the text importer?

Essentially, I have 6 fields in my data file and would like to add a 7th field that would be loaded with the value in sysdate.

Thanks in advance.

 

[Marco Kalter]

This is currently not possible, all imported data has to be linked to a field from the import file. The only option is a default value at the column level, or a before insert row level trigger.