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
    Posts
    4

    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
    Posts
    683

    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.

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

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    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
    Posts
    9,729

    Default RE: Force Null to Empty

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

    Matt

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.