topic Re: How To split EXCEL and DELIMTED FILES in Talend Studio

How To split EXCEL and DELIMTED FILES

_AnonymousUser — Sat, 08 Sep 2012 11:45:05 GMT

Hi Everyone,
Am new to talend and i want to know how can i split a 1GB EXCEL and Delimited files into several output files.Is there any way to split if Yes How?

Thanks In Advance,
Sony

Re: How To split EXCEL and DELIMTED FILES

Anonymous — Sun, 09 Sep 2012 15:01:10 GMT

Hi
There is an option 'Split output in several files' in the advanced setting tab of tFileOutputDelimid. You can generate N rows in each file.

Re: How To split EXCEL and DELIMTED FILES

_AnonymousUser — Fri, 10 Oct 2014 12:04:38 GMT

How split excel file into several files, I got 14 Lakhs records and excel contains only 10 Lakh records now i need to split 4 lakh to another file... please suggest my email is skp.bhupati@gmail.com

Re: How To split EXCEL and DELIMTED FILES

Anonymous — Fri, 10 Oct 2014 15:02:35 GMT

Hi,
As Shong has mentioned, you can use the 'Split output in several files' option in the Advanced Settings tab of the tFileOutputDelimited. This can ease the processing load, if you have a very large file. A setup may be:
tFileInputDelimited --main--> tFileOutputDelimited --on subjob ok--> tFileList --iterate--> further processing (to DB, etc.)
(your very large file) (split file on every (loop through you
100000 rows) splitted files)
The tFileInputDelimited is meant for CSV files. There are similar components for Excel files.