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

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

Anonymous — Sat, 16 Nov 2024 08:48:26 GMT

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 — Thu, 25 Jan 2018 12:22:45 GMT

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

Anonymous — Thu, 25 Jan 2018 12:26:48 GMT

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

Do I need to sync column also in the below,

TRF — Thu, 25 Jan 2018 15:01:34 GMT

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