topic Re: Fileoutput can create new column/field in mysql?? in Talend Studio

Fileoutput can create new column/field in mysql??

Anonymous — Sat, 16 Nov 2024 04:08:15 GMT

Is it possible to create a new filed/columns in the table of my mysql database using tfileoutputdelimited with a tmap?

Re: Fileoutput can create new column/field in mysql??

manodwhb — Wed, 13 Nov 2019 09:02:26 GMT

@alvincenson , You were question bit confusing , yes you can create a new column to have in output file in tMap and then can connect to tfileoutputdelimited .

Re: Fileoutput can create new column/field in mysql??

Anonymous — Wed, 13 Nov 2019 09:06:04 GMT

sorry hehehe

what i want is to create a new column/field to my table using my file delimited columns. sorry for my confusing question

Re: Fileoutput can create new column/field in mysql??

manodwhb — Wed, 13 Nov 2019 09:22:45 GMT

@alvincenson , If I understand correctly while you were loading data from file to table you need to have one more field you can create in tMap in the almost right side down there will be + symbol can add new required filed.

Re: Fileoutput can create new column/field in mysql??

Anonymous — Wed, 13 Nov 2019 09:32:00 GMT

I want the columns created at my schema to be created also at my table field in my database when i run the jo

Re: Fileoutput can create new column/field in mysql??

manodwhb — Wed, 13 Nov 2019 09:36:54 GMT

@alvincenson , you donot want _Emp_Company column into data base meas remove the column from output section then select the colun to be reomve and click on X in top-down of the right side of tMap. and in tDBoutput select the action on table create a table if exits.

Re: Fileoutput can create new column/field in mysql??

Anonymous — Wed, 13 Nov 2019 09:39:07 GMT

I edited my last reply sir. i dont want to remove the _emp_company because it the only column/filed in my database. but what i want is to add the other columns in the tmap also be created at my tables in database after running the job

Re: Fileoutput can create new column/field in mysql??

manodwhb — Wed, 13 Nov 2019 09:41:25 GMT

@alvincenson , you need to change the Action on table of Basic setting of tMysqlOutput is Drop table if exists and create .

Re: Fileoutput can create new column/field in mysql??

Anonymous — Wed, 13 Nov 2019 09:47:19 GMT

@manodwhb THANK YOU VERY SO MUCH SIR !!! can i add you on some social app so i can ask directly if i have other questions in the future?

Re: Fileoutput can create new column/field in mysql??

manodwhb — Wed, 13 Nov 2019 09:49:32 GMT

@alvincenson ,what is that special app ?

Re: Fileoutput can create new column/field in mysql??

Anonymous — Wed, 13 Nov 2019 09:52:08 GMT

social application like facebook. or like email