Need to get all flat files into one flat file

[reshma11]

I have a requirement that I need to get all the output flat files into one flat file separated with file name. Can any one help me on this how to get this done.

[chulett]

So... you need to generate it like that from the start or can you generate them separately and then combine them afterwards? The latter is just 'concatenation' in a loop and something you could script. The former... would have to ponder that.

[reshma11]

I am generating them separately and I need to combine them afterwards. How can I do that.

[nagarjuna]

i think you can do it in sequential file stage . Read multiple files using a sequential file and use the option FileName column.

[chulett]

As noted, a script would be fairly simple. Do a 'for' loop thru the files, echo the filename to the output file and then cat the file itself. Use '>>' redirection in each case to append rather than overwrite.

[reshma11]

In sequential file stage options filter = awk ' BEGIN { print "#pHEADER#"; } { print; } END { print "#pTRAILER#"; } '

Thanks

[Sainath.Srinivasan]

Code: Select all

for fileName in `ls -1`
do
  echo $fileName >> yourFileName
  cat $fileName  >> yourFileName
done