I thought it would be much simpler to do that but could you please provide advice on the following:
I have an excel file which contains about 10 rows only. I want to use this excel file and link it with another
table using tMap and then load data from both tables into another Oracle table.
When I run the job I notice from the excel file it reads 0 rows which makes no sense since there are 10 rows in the excel file.
Also in the execution window I see with red colour "null" - I believe for every row I have in my Excel file.
Any advice or work around of what might have caused this problem?
Thank you in advance.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema