Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Split fields

  1. #1

    Default Split fields

    Hello,


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

    Default RE: Split fields

    Hi,


    I added bug tracker 2001 for this.



    Thank you for your valuable feedback!



    Kind regards,

    Matt

  3. #3
    Join Date
    Mar 2006
    Posts
    683

    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.



    Nic
    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.