Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Using Filter rows

  1. #1
    Join Date
    Aug 2008
    Posts
    9

    Unhappy Using Filter rows

    I want to check if a field is empty or not. How can I make it in Filter Rows?

    Pls help.

    Thanks

  2. #2

    Default

    Well surely its if the field = null then send to the true output step if it = false then is goes to the false output step.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3
    Join Date
    Aug 2008
    Posts
    9

    Default

    Thank you

  4. #4

    Default

    There is a difference between NULL and empty (String/Varchar).
    Check for NULL is made with "value IS NOT NULL" (in both Kettle and SQL).
    Check for emptiness is done with "LEN(value) = 0" in SQL or '= "" ' in Kettle.

    Christoph
    Last edited by christophWeißenborn; 09-02-2008 at 04:26 AM.

  5. #5
    Join Date
    Aug 2008
    Posts
    9

    Default

    so what will i particularly place in the 'value' box in Filter Rows? Is it ok if I will put there a "NULL" string?

  6. #6

    Default

    I do not know which condition you need. Your input values predefine that.
    To build your condition do
    1. choose the field
    2. choose the function: "IS NULL" or "="
    if appropriate 3. choose the value (for comparing)

    Point 3 is not appropriate if you choose "IS 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.