Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I want use some context values for sql query.
Query will be something like: select * from table where value in (context.values);
Those context values are stored in a txt file and they are several, like: monday, friday, saturday.
the query returns no values, because it's looking for context like a string.
How can I make i read context like separated values?
Or is there other better solution?
"SELECT Col1, Col2, Col3 FROM mytable WHERE talend_context =" +context.yourVal
"SELECT Col1, Col2, Col3 FROM mytable WHERE talend_context ='" +context.yourVal +"'"