Six Stars

How to combine/concatenate 2 string fields and create a new field in MySQL database

Hello Folks,

 

I am new to Talend and I have requirement to create a new field in output MySQL database.

 

My input has Var 1 and Var 2 which are of string type.

 

And I want to concatenate these 2 fields and generate a new field in MySQL database.

 

This is what I followed till now:

in TMap output - added a new column and written an expression 

Var1 + Var2 

And how do I pass this to a new field and create the same in Output MySQL db.

 

Currently I have -? Create the table if not exist and insert the rows type.

 

 

Regards,

Deepak

3 REPLIES
Thirteen Stars TRF
Thirteen Stars

Re: How to combine/concatenate 2 string fields and create a new field in MySQL database

Propagate the schema to the tMySQLOutput component. Should be enough, no?

TRF
Six Stars

Re: How to combine/concatenate 2 string fields and create a new field in MySQL database

After I made the changes I have clicked on the propogate changes. 

 

Do I need to sync column also in the below,

 

Warnerpic2.PNG

Thirteen Stars TRF
Thirteen Stars

Re: How to combine/concatenate 2 string fields and create a new field in MySQL database

Your schema looks right, the job should work (if the column exists in the DB).


TRF