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?
how do you have created the excel structure in your job ? and the link in tMap ? It's better to import the xls structure with Talend and it shows you a data preview.
I created a new File Excel from Metadata and then linked it with an existing excel file from a location from my computer. Then I use this excel file as a tFileInputExcel and by a tMap I want to link it with a table. When the procedure begins to retrieve data from the Excel file I see 0 rows coming from the excel which is strange since it has about 10 rows which I could see them during the wizard...
