Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Force Null to Empty

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Apr 2006

    Default Force Null to Empty

    I am just starting to use Kettle and I have a small problem.

    All the empty fields retrieve in a generic database are transform to NULL. Is there any way to avoid that. I want all those fields to be empty in my MySQL database.

    Please help.

  2. #2
    Join Date
    Mar 2006

    Default RE: Force Null to Empty

    two easy ways that may not be the best way,
    one set the default for the field in the db
    two ifnull statement to the SQL.

    Hope that helps you get up and running quickly.

    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  3. #3
    Join Date
    Sep 2005

    Default RE: Force Null to Empty

    If this is the only ways....

    But a flag in the output for this would be nice....Even with texte file. So CSV would be "","","" instead of ,,,

    Have a nice day...

  4. #4
    Join Date
    Nov 1999

    Default RE: Force Null to Empty

    In text file output you can specify the value to use in case it's Null.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.