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.
