Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Hi there,
 i need to split a large excel file >5mb into smaller files .
Please help!
Thanks in adv,
Hachi
Labels (2)
14 Replies
Anonymous
Not applicable
Author

Hi,
It's working 0683p000009MACn.png
Thanks Sabrina.
Regards,
El Hassan
Anonymous
Not applicable
Author

Hi El Hassan,
Great it works. Feel free to let us know if there is anu further help we can give.
Best regards
Sabrina
_AnonymousUser
Specialist III
Specialist III

I am getting the following error when converting from csv to xls. connecting to socket on port 4042
connected
Exception in component tFileOutputExcel_2
java.io.FileNotFoundException: D:\Public\talend output test\Testing\D:\Public\talend output test\Testing\B0.csv.xls (The filename, directory name, or volume label syntax is incorrect)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at java.io.FileOutputStream.<init>(FileOutputStream.java:110)
at project.doublecheck_0_1.doublecheck.tFileList_1Process(doublecheck.java:555)
at project.doublecheck_0_1.doublecheck.runJobInTOS(doublecheck.java:1024)
at project.doublecheck_0_1.doublecheck.main(doublecheck.java:881)
disconnected
Job doublecheck ended at 17:49 09/01/2017.
preddy79
Contributor
Contributor

Hi Xdshi,
I've similar job that gets data from DB and writes to tfileoutputdelimit, as the volume is 1M records, wants write to small files with 1000 records. when the job  runs it creates 100 files in 2 mins but it wont stop there, it keeps overwriting multiple times almost like 50+ times before job completes successfully.
Why is it overwriting so many times, is tehre anything wrong in my configuration or settings. please help. 
thanks and regards  
Anonymous
Not applicable
Author

Hi preddy79,
Is there any error message printed on console?  On which build version you got this issue?
Screenshots of your job setting will be preferred.
Best regards
Sabrina