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.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Take a look at this technical overview video of Talend API Designer
Take a look at this video about Talend Integration with Databricks