I just create a simple job to show you how to use the context var in slq query. Please see my screenshots.
Please add some screenshots or error traces. It's help to understand where is your mistake or problem.
What's the name of the ROW in your jobDesign ? and what's exactly the name of the Field ?
The trouble is because you call the variable with a wrong VARIABLE_NAME. Unknown for the code generator.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend