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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.