How to split file by number of lines?

Five Stars

How to split file by number of lines?

Hi,

 

I have to split large excel file by number of lines , per 1000. (with the limitation of the file import system.)

How can I do setting on Tanend to create files in 1000 lines?

I did not know where I could specify the specification of every 1000 rows.

 

This url is similar to what I want to do,but currently I couldn't use some Database, only using csv/Excel.

https://community.talend.com/t5/Design-and-Development/tFileOutputDelimited-split-output-in-multiple...

 

Thank you.

  


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: How to split file by number of lines?

Hi,

If you are able to have the output to CSV format, connect your tFileInputExcel to a tFileOutputDelimited component.

Then, go to the Advanced Settings panel, tick the option "Split output in several files" and enter the desired number of lines for each output file (1,000 as the default).

If your output must be Excel format, you'll have to add a subjob to iterate over the CSV files generated and to create 1 Excel file per input CSV file.


TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: How to split file by number of lines?

Hi,

If you are able to have the output to CSV format, connect your tFileInputExcel to a tFileOutputDelimited component.

Then, go to the Advanced Settings panel, tick the option "Split output in several files" and enter the desired number of lines for each output file (1,000 as the default).

If your output must be Excel format, you'll have to add a subjob to iterate over the CSV files generated and to create 1 Excel file per input CSV file.


TRF
Fifteen Stars TRF
Fifteen Stars

Re: How to split file by number of lines?

Did this help?
If so, thank's to mark your case as solved (Kudo also accepted).


TRF

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now