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.

Regards.
One Star

Re: How to export big data to Excel?

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.
Highlighted
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads