Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Using environment variables in a 'filter rows' step

  1. #1

    Default Using environment variables in a 'filter rows' step

    Hi,

    I want to use a environment variables in a 'filter rows' step. I want to filter all the rows using field = ${var_ent}
    var_ent is integer and the field is integer.

    It show me that error 'couldn't convert string to integer'

    Any advice will be greatly apreciatted

    Thanks in advance

  2. #2
    njain111 Guest

    Default

    Use 'Get Variables' to get var_ent then it will be available as a field to be used in 'filter rows'

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by juanvg1972 View Post
    var_ent is integer and the field is integer.
    By definition, all variables are strings... Do as njain suggested, and then convert it to an int.

  4. #4

    Default

    Thanks for your help!!

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.