Merge @ Excel file to One excel file

[Anonymous]

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

[navds]

Input: Two tFileInputExcel

Intermediate: tUnite

Output: one tFileOutputExcel

[Anonymous]

Thank you for your quick reply 

how to configure tunite .

I just attached the screenshot.

Please find the attachment 

Capture 005.PNG

[Anonymous]

Hi @navds ,

I got this error.

Could you please help me out.

Please find the attachment 

Capture 006.PNG

[Anonymous]

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]

[navds]

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.

[akumar2301]

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

[Anonymous]

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 🙂