AnsweredAssumed Answered

SQL Statement using variables in PDI

Question asked by Vadim Kalyshkin Employee on Feb 20, 2019
Latest reply on Feb 25, 2019 by Carl van Denzen



i need to get the data from the database (called "employees") which has the columnt (called "name")


I have defined two variables "table" and "name" with the following values


table = employees

name = john


In the table Input Block I've added the following:


select * from ${table} where name = ${name}


and it doesn't work (because of the "where" part) I've added the check box to the "Replace varibles in script" 


Could someone help to write the statement correct?