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

Hello

 

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?

 

Thanks

Outcomes