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.
After I made the changes I have clicked on the propogate changes.
Do I need to sync column also in the below,
Your schema looks right, the job should work (if the column exists in the DB).