All Forums Tools
pmarshall99 1 post Joined 02/12
21 Feb 2012
Data Manipulation in FastLoad

I have a number of delimited files, each of the same format and each has a date as a part of the filename.


Is there a way, using FastLoad, that I can add a column to the data during the load that contains the date portion of the file name?


I tried simply adding a SUBSTR to the INSERT statement but received the error "Expression not allowed in FastLoad"


Thanks for your help



I am using TTU 13.10

You must sign in to leave a comment.