Update Table based on Excel Worksheet

Five 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?


Accepted Solutions
Eight 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


All Replies
Eight 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

Five Stars

Re: Update Table based on Excel Worksheet

Thanks.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch