topic Re: Merge @ Excel file to One excel file in Talend Studio

Merge @ Excel file to One excel file

Anonymous — Sat, 16 Nov 2024 06:19:59 GMT

Hi,

I am trying to inserted two excel file in to one excel sheet.

Please help me out.

Please find my attachment.

2 excel file having same column.

Thank you,

Sanjay

Re: Merge @ Excel file to One excel file

navds — Thu, 14 Mar 2019 17:34:15 GMT

Input: Two tFileInputExcel

Intermediate: tUnite

Output: one tFileOutputExcel

Re: Merge @ Excel file to One excel file

Anonymous — Thu, 14 Mar 2019 17:45:04 GMT

Thank you for your quick reply

how to configure tunite .

I just attached the screenshot.

Please find the attachment

Capture 005.PNG

Re: Merge @ Excel file to One excel file

Anonymous — Thu, 14 Mar 2019 17:48:25 GMT

Hi @navds ,

I got this error.

Could you please help me out.

Please find the attachment

Capture 006.PNG

Re: Merge @ Excel file to One excel file

Anonymous — Thu, 14 Mar 2019 17:50:14 GMT

hi @navds ,

this is my error,

Starting job File_2_Excel at 13:46 14/03/2019.

[statistics] connecting to socket on port 3382
[statistics] connected
For input string: "N/A"
For input string: "3018811441X3"
For input string: "8604920736EX"
Exception in thread "Thread-0" Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
[statistics] disconnected
at jxl.read.biff.File.read(File.java:217)
at jxl.read.biff.Record.getData(Record.java:117)
at jxl.read.biff.CellValue.<init>(CellValue.java:94)
at jxl.read.biff.LabelSSTRecord.<init>(LabelSSTRecord.java:53)
at jxl.read.biff.SheetReader.read(SheetReader.java:412)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
at jxl.read.biff.SheetImpl.getRows(SheetImpl.java:471)
at excel_file_to_sql_server_table.file_2_excel_0_1.File_2_Excel.tFileInputExcel_1Process(File_2_Excel.java:5734)
at excel_file_to_sql_server_table.file_2_excel_0_1.File_2_Excel.runJobInTOS(File_2_Excel.java:8466)
at excel_file_to_sql_server_table.file_2_excel_0_1.File_2_Excel.main(File_2_Excel.java:8315)
java.lang.OutOfMemoryError: Java heap space
at java.util.LinkedList.listIterator(Unknown Source)
at java.util.AbstractList.listIterator(Unknown Source)
at java.util.AbstractSequentialList.iterator(Unknown Source)
at routines.system.RunStat.sendMessages(RunStat.java:280)
at routines.system.RunStat.run(RunStat.java:244)
at java.lang.Thread.run(Unknown Source)

Job File_2_Excel ended at 13:49 14/03/2019. [exit code=1]

Re: Merge @ Excel file to One excel file

navds — Thu, 14 Mar 2019 18:34:26 GMT

How many rows do these input files have ?
The tUnite doesn't require complicated configuration, just make sure the inputs have the same schema, then click on "Sync columns" to propagate the schema.

Re: Merge @ Excel file to One excel file

akumar2301 — Thu, 14 Mar 2019 21:47:17 GMT

If big excel file , try event mode reading in advance setting.

Re: Merge @ Excel file to One excel file

Anonymous — Fri, 15 Mar 2019 11:41:11 GMT

Hi,

To avoid memory related issues, please check this article too.

https://help.talend.com/reader/XWYVXqDVIHwy7uFCjwQHYw/FQoY~9hnjr0Ta_l7gxhEcg

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂