Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create a new filed/columns in the table of my mysql database using tfileoutputdelimited with a tmap?
@alvincenson , you need to change the Action on table of Basic setting of tMysqlOutput is Drop table if exists and create .
@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 .
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
@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.
I want the columns created at my schema to be created also at my table field in my database when i run the jo
@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.
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
@alvincenson , you need to change the Action on table of Basic setting of tMysqlOutput is Drop table if exists and create .
@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?
@alvincenson ,what is that special app ?