Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: IS EMPTY not found in Filter row step

  1. #1

    Default IS EMPTY not found in Filter row step

    Hi
    I an new to PDI. For a client, old server has PDI version 4.4.1. And the new server has 6.1.0. In one of the transformation on the old server, filter row uses IS EMPTY function. But I am not able to re-create the same step since there is no IS EMPTY function to choose from the list for Filter row step. Can I use IS NULL? Is it the same? I have attached the screenshots.
    Thanks!


    Priya
    Attached Images Attached Images   

  2. #2
    Join Date
    May 2014
    Posts
    358

    Default

    Disclaimer: I have actually never used the IS EMPTY, I mostly use PDI 5.x.
    I suppose the currency_division field is a string? What else could be empty?
    From what I know, Kettle can distinguish between null and empty strings, so a string which is not null may be empty. Unless, you change a property in the kettle.properties file which can change this behavior and then null is handled the same way as an empty string. But don't do that, that could cause all sorts of funny behavior especially in an old codebase.
    If you really want to check for an empty string, I would recommend a Java Filter step - there you can write an expression like: field == null || field.isEmpty()

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.