Hello, everyone. I am new to Talend and will really appreciate your help. I am using Talend 6.3. I have one excel file having multiple sheets(Total 4 sheets) and I want to read data data from all sheets and populate it in tGreenplumpOutput if possible. I have tried using:
tGreenplumConnection -> tParallelize -> tFileInputExcel(Total 4 components for 4 sheets) -> tGreenplumOutput(Total 4 components for 4 tFileInputExcel)
The rows count is getting paused whenever I run the job. Please help me to rectify this issue or suggest me an alternative solution for this in you have any .
I am assuming for all the 4 sheets you have same number of columns, so the schema remains same. In that case why not select the option - "All Sheets" for tFileInputExcel. So, your job would look like:
tGreenplumConnection -> on subjobok -> tFileInputExcel -> main -> tGreenplumOutput
tFileInputExcel -> on subjob ok -> tGreenplumCommit
Thank you for your reply Abhishek.
All the 4 sheets are having different number of columns. So this approach will not work I guess.
Could you please add tlogrow instead of Greenplum and see the result. I guess it will work fine in that case. So issue could be at the loading part to Greenplum.
On a different note, are you trying to load the data from all sheets to same table? If you want to load Sheet1 to TableA, Sheet2 to TableB, etc. then you need to add the Sheet names in the excel input component.
Thank you Nikhil for your reply.
I will try this alternative solution as you suggested by using tlogrow instead of greenplum.
I am loading Sheet 1 to Table A, Sheet 2 to Table B, etc.. and I have mentioned the Sheet name in the tFileInputExcel's Sheet List.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.