topic Re: How to export big data to Excel? in Talend Studio

How to export big data to Excel?

_AnonymousUser — Sat, 16 Nov 2024 13:29:46 GMT

Hi guys! I need some orientation about a thing. Well I've a big MySQL database and I need to export some data to Excel, that's ok and I can do that with Open Studio.
But Excel have some limitations about the rows count (in 2003 near of 300.000), and here is my question:
Can I, somehow count the number of rows and if I have a number like 300.000 to create another file with another name?
Thanks in advance for your replies.

Regards.

Re: How to export big data to Excel?

Anonymous — Sun, 21 Mar 2010 16:21:00 GMT

Hi,
You can do a "select count(0) from yourTable" before the extraction. After you have juste to filter your output in a tMap to export on Excel or CSV file.
You can also do this dynamically with a sequence routines.Numeric.sequence("sequenceName", 0, 1) on your tMap. It's easy to filter the output with a new variable column.

Re: How to export big data to Excel?

Anonymous — Mon, 22 Mar 2010 13:03:08 GMT

Hi eguerin thanks for your reply.
So I've no problems to export my data via tMap to an Excel, my problem is the data count because I've to many rows.
I was checking about Numeric.sequence, but I can't understand for now how I can dynamically create Excel files with this variable... I'm very lost please help.
Thanks in advance, regards.