Need to have Input File name as Output

[monalisa21]

A job is reading multiple files using File Pattern.
Let my input files are A1.txt,A2.txt,A3.txt,A4.txt,A5.txt.

Input file pattern is A*.txt.

I want to have exact file name corresponding to each record read from that source file.

Output should be

COL1aa,COL2aa,A2.txt (comment:COL1aa,COL2aa read from A2.txt)
COL1bb,COL2bb,A4.txt (comment:COL1bb,COL2bb read from A4.txt)

Please help

[Aparna_A]

Hi,

Include the option File Name Column available in OPTIONS in sequential file PROPERTIES tab. Then include this column name (default being fileNameColumn) in the Columns Tab.

[bkumar103]

Hi Aparna,

I didnt find the option you have mentioned.
I find following option in the option tab of sequential file(If used as output):

cleanup on failure
First line is column name
Reject mode

I find following option in the option tab of sequential file(If used as input):

First line is column name
Keep file partitions
missing file mode
Reject mode
report progress

Could you please tell, exactly where is the option.

[srinivas.g]

when u click the option tab, the right hand side it appears

[Aparna_A]

Hi,
As Srinivas mentioned, the File Name Column property appears under "Available properties to Add" when you click on Options under Proerties tab.