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

[Anonymous]

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

[TRF]

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

[Anonymous]

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

Do I need to sync column also in the below,

[TRF]

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