Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Split fields

  1. #1

    Default Split fields


    I am trying to split a field into two fields using "Split Fields", this works perfectly when the field is not empty across all rows. But, when meeting a row where the field to split is empty it throw an error and the rows extraction stops.

    thanks for help

  2. #2
    Join Date
    Nov 1999

    Default RE: Split fields


    I added bug tracker 2001 for this.

    Thank you for your valuable feedback!

    Kind regards,


  3. #3
    Join Date
    Mar 2006

    Default RE: Split fields

    one thing I did to get round this bug was to use a IFNULL statement in my sql to garentee that it was going to have something in it even if after the split it was just a space and a space.

    I hope might help you get it working sooner than the bug fix.

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

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.