Excel spreadsheet load

lak4u · Post by **lak4u** » Wed Jul 22, 2009 2:41 pm

Hi,

I need to create .csv file but I need to leave first 5 rows as empty and load it from 6th row.How can I leave first 5 as empty rows?

Please help

Thanks

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Jul 22, 2009 3:59 pm

Easiest way is to use a Before Job ExecDos command to copy a csv file with five empty rows to the correct filename before you start your job. Then have your job append to the file instead of overwriting it.

chulett · Post by **chulett** » Wed Jul 22, 2009 8:31 pm

Agreed. I usually want to gravitate to an 'after job' solution but this is better done before.

lak4u · Post by **lak4u** » Thu Jul 23, 2009 9:45 am

asorrell wrote:Easiest way is to use a Before Job ExecDos command to copy a csv file with five empty rows to the correct filename before you start your job. Then have your job append to the file instead of overwriting it.

Hi Andy and Craig

Thanks for your answer.