Four Stars

Update Table based on Excel Worksheet

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

Re: Update Table based on Excel Worksheet

Hello,

Capture.JPG

 

 

 

 

 

 

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

2 REPLIES
Seven Stars

Re: Update Table based on Excel Worksheet

Hello,

Capture.JPG

 

 

 

 

 

 

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

Four Stars

Re: Update Table based on Excel Worksheet

Thanks.