Avoiding header when reading from mutiple flat files to single flat file

• satish.t

  Mr or Mrs. 500

  Points: 521

  More actions

  April 6, 2010 at 6:48 am

  #139731

  Hi There..

  I have a situation where I need to read data from mutiple flat files to single flat file.

  The problem is every source file is having column headers, so when I am reading data from mutiple files and appending into single file, the headers are also getting appended mutiple times. I need to avoid this.

  I have tried Data rows to skip and Headers rows to skip but they are skipping rows after the header columns as I have identified that the first row is header columns...

  need some pointers

  thanks,

  satisht

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  April 6, 2010 at 6:59 am

  #1146449

  As long as you can find some suitable selection logic, you could use a conditional split to redirect header rows (to nowhere).

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel