[resolved] split large excel file to 2 or more excel files

[Anonymous]

Hi there,
 i need to split a large excel file >5mb into smaller files .
Please help!
Thanks in adv,
Hachi

[Anonymous]

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.
Best regards
Sabrina

[Anonymous]

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.
Best regards
Sabrina

Hi Sabrina,
can the splitted output file be excel ..
large excel file --- 2 excel files.

[Anonymous · Accepted solution]

Hi,
There is no "split" option in tfileoutputexcel component.
You can tranfer your output delimited files into excel files.
tfileinputexcel-->tfileoututdelimited(split)-->tfilelist(loop through your splitted files)-->further processing(excel output, DB)
                  

Best regards
Sabrina

[Anonymous]

Hi,
There is no "split" option in tfileoutputexcel component.
You can transfer your output delimited files into excel files.
tfileinputexcel-->tfileoututdelimited(split)-->tfilelist(loop through your splitted files)-->further processing(excel output, DB)
                  

Best regards
Sabrina

Thanks sabrina..  this hepls!

[Anonymous]

Hi Hachi,
Great it is working. Let us know if there is any further help we can give.
Best regards
Sabrina

[Anonymous]

Hi,
I am new on Talend. I want to split a large excel file.
I did not understand how to use: tfileinputexcel-->tfileoututdelimited(split)-->tfilelist(loop through your splitted files )-->further processing(excel output, DB)
Please, can you explain exactly what to?
Thanks.
Regards,
El Hassan

[Anonymous]

Hi,
 Do you want to split your big excle file into several delimited files or excel files?
 Due to "split" option will be available in tfileoutputdelimited component. If you want to get several delimited files, you can just use  tfileoututdelimited to achieve it.
The work flow should be: tfileinputexcle-->tfileoutputdelimited(In advanced settings, here is an "split output in several files" option).
If you want to get several excel files, you have to  transfer your output delimited files into excel files firstly.
The solution was provided as above. 
There are two subjobs:
1: Split your big excel file into several delimited files
2: T ransfer your output delimited files into excel files
tfileinputexcel-->tfileoututdelimited(split)-->onsubjobok-->tfilelist(loop through your splitted delimited files )-->further processing(excel output, DB)
Let us know if it is Ok with you.
Best regards
Sabrina

[Anonymous]

Hello Sabrina,
Thank you for your replay.
I want to split an excel file into several excel files.
I already split the big excel file "DFC_Chiffrage_Supplier_Export.xls" into several delimited files(DFC_Chiffrage_Supplier_Export0.xls, DFC_Chiffrage_Supplier_Export1.xls, DFC_Chiffrage_Supplier_Export2.xls and DFC_Chiffrage_Supplier_Export3.xls).
I can not transfer the output delimited files into excel files.
Please, how can I do that, step by step? I m new on Talend
Thanks.
Regards,
El Hassan

[Anonymous]

Hi,
You can use tfilelist to retrieve your several delimited files from a folder and output them through tfileoutputexcel.
The workflow should be:tfilelist(using file mask as *.csv)-->tfileinputdelimited->tfileoutputexcel.
Here is a component reference about:TalendHelpCenter:tFileList
To make it clear, I have designed a simple demo job for you. Please take a look at my screenshots for details.
Feel free to let us know if it is OK with you.

Best regards
Sabrina