topic Re: Limit no of rows in tFileoutputExcel 6.3 in Talend Studio

Limit no of rows in tFileoutputExcel 6.3

ShastriV — Thu, 17 Oct 2019 18:21:56 GMT

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?

Re: Limit no of rows in tFileoutputExcel 6.3

akumar2301 — Thu, 17 Oct 2019 21:27:36 GMT

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.

Re: Limit no of rows in tFileoutputExcel 6.3

Anonymous — Tue, 22 Oct 2019 08:14:03 GMT

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.

Re: Limit no of rows in tFileoutputExcel 6.3

ShastriV — Tue, 19 Nov 2019 15:16:04 GMT

Thank you Ajinkya, I will try your solution.