How to export big data to Excel?

One Star

How to export big data to Excel?

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.

One Star

Re: How to export big data to Excel?

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.
One Star

Re: How to export big data to Excel?

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now


Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.


Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.