topic Re: Update Table based on Excel Worksheet in Talend Studio

Update Table based on Excel Worksheet

grigby — Tue, 13 Feb 2018 22:13:52 GMT

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?

Re: Update Table based on Excel Worksheet

lojdr — Fri, 16 Feb 2018 17:27:09 GMT

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

Re: Update Table based on Excel Worksheet

grigby — Mon, 19 Feb 2018 14:41:06 GMT

Thanks.