title: Convert string to boolean with Pentaho Kettle
body: <p>I'm moving an Oracle db to a Mongo DB, using Pentaho Kettle. I've succeded in doing almost everything I wanted, but I just have a last problem.</p>
  
  <p>In the oracle db, they have a field that have two states : Y or N, instead of a nice boolean <em>true</em> and <em>false</em>. I wanted to make a mapping in the transformation to say that Y is <em>true</em> and N is <em>false</em>, but Pentaho translates this as strings, and not like real <em>true</em> and <em>false</em>.</p>
  
  <p>Do I have an easy way to set up my booleans?</p>
  
  <p>Thanks in advance!</p>