[resolved] How to update bridge table

One Star

[resolved] How to update bridge table

Hi,
Mac OS El Capitan, TOS 6.1, Postgresql
How can i update a bridge table ?
update table
set colB = NewValue
where colA = value AND colB = OldValue;
Seems that this option can be found in Use field options.
How can i transmit those values for colB from tMap ??
Best regards,
Carlos

Accepted Solutions
Community Manager

Re: [resolved] How to update bridge table

You will need to use database "Row" component. In this component you can write your own update statement and populate the parameters as you wish (using Java String concatenation). 

All Replies
Highlighted
One Star

Re: [resolved] How to update bridge table

nobody for me ?
I want to transmit to the bdd output two different values for the same column to be able to make a set col = newvalue where col=oldvalue ?
Community Manager

Re: [resolved] How to update bridge table

You will need to use database "Row" component. In this component you can write your own update statement and populate the parameters as you wish (using Java String concatenation). 
One Star

Re: [resolved] How to update bridge table

Thanks Richard.
Will test it asap.
Carlos

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 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog