Update Table based on Excel Worksheet

[grigby]

Hi,

Some guidance/help requested.

An excel worksheet contains data that needs to be used to update a table. There are 10 columns in the worksheet, but only one of the columns contains the data thatneeds to be update in the table. The worksheet also contain a column with the record number, whcih matche the record found in Talend (.e record 23 on the worksheet matches record 23 in Talend.

What is the easiset job that can be created to complete this task?

[lojdr · Accepted solution]

Hello,

1) tFileInputExcel will select all columns (or subset)

2) tFilterColumns will filter rest of unneeded columns

3) tMySQLOutput will update table

ad 3) Be sure, that you use checkbox for Key to inform Talend which value should be used for lookup.

Hope it helps.

Lojdr

[grigby]

Thanks.