Hi Talend Community,
I have a job that needs to do the following:
extract data variable from table -> Iterate row-> select new data set based on variable input.
Here is my current job
Here is my tMysqlInput_2 select:
"select result from details where customerid ="+((String)globalMap.get("row1.customer"))
When I execute I get the following error
Exception in component tMysqlInput_2 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'AF214DS' in 'where clause'
It seems to be replacing the variable with the column name....
Solved! Go to Solution.