title: How to migrate tables with consistent foreign keys in Pentaho Kettle?
body: <p>I have csv file with data</p>
  
  <pre><code>name, state
  </code></pre>
  
  <p>.</p>
  
  <p>I want to put those data to tables:</p>
  
  <pre><code>Table1{id[PK], name}
  State{table1_id[FK], state}.
  </code></pre>
  
  <p>Main problem here is to how store newly created Table1 id and use it during inserting to State table
  How to do this with pentaho?</p>