Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Ok in that case, you may want to try using a tmysqloutput component instead of tmysqlrow.
https://help.talend.com/reader/D_AHwO__5PjfWaaJKtDD1A/7IH8hy9EzjA85l5C4boMdA
I read your use case again. Doesn't look like it will work using the tMysqloutput command.
As an alternative, We could output the distinct FLAG values to a flat file first.
And then you can do something like this,
The tMysqlRow should have your update query for each distinct flag in the input file.
Yes before we checked tmysqlrow ,we wrote the simple query select query its working fine ,
For Example:
I get the CSV data file to insert into the DataBase , its working fine . At the same time need to update the another table in Database to dynamically based on the records , we using tMap function to insert the data ,same as we try here get the some value & Update the another table.
we used the "update.invoice" but its shows error
So how we can solve this issue , any other methods have to update the database .
Ok in that case, you may want to try using a tmysqloutput component instead of tmysqlrow.
https://help.talend.com/reader/D_AHwO__5PjfWaaJKtDD1A/7IH8hy9EzjA85l5C4boMdA
I read your use case again. Doesn't look like it will work using the tMysqloutput command.
As an alternative, We could output the distinct FLAG values to a flat file first.
And then you can do something like this,
The tMysqlRow should have your update query for each distinct flag in the input file.
Thanks for Support,
Now the update query is working fine , in tMysqlrow_1
ADDED:
When we connected the tMysqlconnection , that update query is working or Else its show that previous error .