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

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

_AnonymousUser — Sat, 16 Nov 2024 13:27:47 GMT

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.

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

Anonymous — Fri, 16 Apr 2010 07:06:08 GMT

Hello
Is the first row column name? Can you send me an exmaple file via email?
Best regards
Shong

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

_AnonymousUser — Mon, 05 Jul 2010 07:29:42 GMT

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