Limit no of rows in tFileoutputExcel 6.3

[ShastriV]

Hi,

I want to Limit no of rows per sheet in output excel 2007 file.

eg: I want to write 100k rows in each excel sheet.

How should I achieve this in excel 2007?

[akumar2301]

You need to split it before writing to excel may be using tfileoutputdelimited(advance option delete)

Then loop through list of generated by and write to same excel but separate sheet.

[Anonymous]

you can try using sequence generator in tMap. create a new variable in transformation tab (middle portion) and assign a value auto increment it +1 and then use the same as filter (eg. count < 100001) in output tab (last portion). 

In short segregate records in multiple outputs based on count.

[ShastriV]

Thank you Ajinkya, I will try your solution.