Carry Over Filename As Output Column
Posted: Thu Jul 29, 2010 9:24 am
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
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