Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-06-14 05:55 AM

Update table column by Lookup from remote CSV file

Hello
I have a requirement to update a column of a table in my Greenplum DB from a CSV file.
CSV file has two columns one of which is a key column and other one is the column to be updated.
I want to know how can I do this update if the file is on a ftp server as I want to run the job in TAC 
and which component will be most efficient for update operation.
Thanks in advance.
Labels (3)
Labels
244 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2016-06-16 04:31 AM
Author

Hi,
With you requirement, you have to download your file from FTP server into local by using tftpget componnet(Talend cannot support for loading file by air) and then load your data from this  csv file into your  Greenplum DB.

Here is " update or insert" option on tGreenplumOutput component which is used to  update a record with a matching primary key.

If you want to run job on TAC, please take a look at document about:TalendHelpCenter:Executing data integration Jobs from Job Conductor
Let us know if this solution is Ok with you.
Best regards
Sabrina
244 Views
0 Likes