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

Patrick

 

I am using TTU 13.10

Tags:
You must sign in to leave a comment.