Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Import data from Excel to Oracle table

Hi all,

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.

Regards,
Leantros

Labels (2)
3 Replies
Anonymous
Not applicable
Author

Hi Leantros,

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.
Anonymous
Not applicable
Author

Hi Carlos,

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...
Anonymous
Not applicable
Author

The problem was the excel file... I just copied the data into another and it works ok. maybe the extension if its workbook or .xlx plays role...