Pentaho

 View Only

 How to use the results row of extraction table into sql execution script

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Tristan Barre's profile image
Tristan Barre posted 05-20-2020 07:54

I would like to use the results of row from a step "extraction table" to bind parameters in a second step whitch is a "sql query execution". When i use the "?" to bind parameters, the value is not replaced.


#Pentaho
#Kettle
#PentahoDataIntegrationPDI
Luciano Donazzolo's profile image
Luciano Donazzolo

Take in mind that you can't use "?" anywhere in the SQL statement.

E.g. it does't work to set the field selection list in SELECT.

If you need to extend parameters to table structure, you may use "ETL Metadata Injection" step.

See more at https://wiki.pentaho.com/display/EAI/Table+Input

Luciano