Page 1 of 1

Carry Over Filename As Output Column

Posted: Thu Jul 29, 2010 9:24 am
by marothisu
Hello,

I was wondering if it is at all possible to "detect" a filename from an input stage such as a Complex Flat File Stage? For example, if I am reading in three files: "records2000.csv", "records2001.csv", and "records2002.csv" from a Complex Flat File Stage, I would like one of the output columns to indicate which file the current record came from.

Is this possible? I am aware there is a File Name column in the Sequential File Stage, but what about Complex Flat File?


Thanks

Posted: Thu Jul 29, 2010 3:31 pm
by ray.wurlod
Complex Flat File stage does not have this functionality.

Indeed I was not aware that this stage can read more than one file at a time.