Pentaho

 View Only

 passing parameter through data grid in pentaho.

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
archana garikapati's profile image
archana garikapati posted 06-26-2019 03:44

passing parameter through data grid in pentaho. please assist how can i pass this paramter or to resolve it.

pastedimage_2


#Pentaho
#Kettle
#PentahoDataIntegrationPDI
David da Guia Carvalho's profile image
David da Guia Carvalho

Use a column for the parameter and get the parameter with a "Get variables" step.

Naveen Kumar's profile image
Naveen Kumar

Adding unto David's response:

No, Value field does not take/resolve the parameter in Data Grid and it takes the value literally (Parameter name as data)

One way is to get the parameter separately using another step (like get variable or UDJE) and merge with your data grid results.

From the screenshot, it appears them in sequence - If so, ensure the order is maintained/re-arranged as required.

Variable or named parameter can only be applicable for fields where there variable icon (blue diamond with $ inside) is indicated.

-Navn