title: Using Pentaho Kettle, how to load data in output table from CSV file with intermediary step reading in an input table?
body: <p>I have a CSV file which contains data I need to load in a database table using Pentaho ETL Kettle. But before loading them in the table, I need to build each row to be inserted with values I get from the CSV file and values I have to collect from another input table (which needs data from the CSV as parameter to collect wanted info). I'm a bit lost with the steps I have to use to build my transformation. Can anyone help ?</p>