One Star

Talend: select column name from excel file and put it as rows

hello
i have recentlly worked on Talend and I have a difficulty concerning how to select column names from an excel file and put it as rows in a mysql table.
My excel files is as follow:
DATE--NAMESGSN-- KPI1--kpi2--kpi3
I want to select just the cells which contains KPI1,KPI2,KPI3 automatically . And my sql table: name KPI contains one column :nameKPI and it is as follow:
nameKPI
---------
KPI1
KPI2
KPI3
How can I do this using Talend components?
Please I need your help. It's very urgent.
THANKS.
2 REPLIES
Community Manager

Re: Talend: select column name from excel file and put it as rows

Hello
Is the first row column name? Can you send me an exmaple file via email?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend: select column name from excel file and put it as rows

Hi, I have related task. And I haven't found solution yet. Please help if you can. Here's my problem
http://jasperforge.org/plugins/espforum/view.php?group_id=99&forumid=108&topicid=76247