Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Filter rows(IN LIST)

  1. #1
    Join Date
    Jun 2007
    Posts
    128

    Default Filter rows(IN LIST)

    Hi,

    How can we use IN LIST of filter rows?Do we need to give a list of values ?I have entered a list of values in the values field but entire list is treated as a single string.

    Thanks
    Sreelatha

  2. #2

    Default

    Hi Sreelatha,
    You have to enter a list of values separated by ;
    like :
    value1;value2;value3 ...

    Rgds

    Samatar

  3. #3
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    is there any limitation on the number of values in the list.I got the following error when i try to run the transformation.

    Unable to save step info to the repository for id_transformation=20

    Unable to save step information to the repository for id_step=319

    Error saving condition to the repository.

    Error inserting row
    Data truncation: Data too long for column 'VALUE_STR' at row 1

    Thanks
    Sreelatha

  4. #4

    Default

    I gess 255

    Samatar

  5. #5
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    I gave less than 100 values and getting the above problem.Is the error becasue of the values or any other reason?

    Thanks
    Sreelatha

  6. #6
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    I tested it varying the number of values.It is working fine upto 50 values.
    Is there any way to make it work with more values?

    Thanks
    Sreelatha

  7. #7
    Join Date
    Mar 2007
    Posts
    216

    Default 255.. characters ?

    Hi,

    Maybe it is 255...characters, instead of values.
    It seems to work with approximatively 50 values, so If the values used to test are about 5 characters long I may be right.
    255 characters is the maximum length of a varchar.
    Maybe you could run your data into multiple filter rows step with approximatively 50 values in each.
    Good luck.

    a+, =)
    -=Clément=-

  8. #8
    Join Date
    May 2006
    Posts
    4,882

    Default

    Tracker created at http://jira.pentaho.org/browse/PDI-186

    Regards,
    Sven

  9. #9

    Default

    I am trying to us a list on an integer column, but there appears to be no way I can define a list of integers. When I select INTEGER as the value type and then enter e.g. 4;6;9;11;, I get a parse error. What do I need to do to make this work?
    If I set the value type to String, the list gets accepted (I suspect though , as string). When I then try and run the transformation I get this output in the log:

    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : java.lang.RuntimeException: Unexpected error evaluation condition [(
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : (
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Month IN LIST []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : AND Day <= []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : OR
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : (
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Month = []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : AND Day <= []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : OR
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : (
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Month = []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : AND Year IN LIST []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : AND Day <= []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : OR Month IN LIST []
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : )
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : ]
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.core.Condition.evaluate(Condition.java:521)
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:49)
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.processRow(FilterRows.java:89)
    2007/10/22 15:30:22 - Filter rows.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : at org.pentaho.di.trans.steps.filterrows.FilterRows.run(FilterRows.java:146)


    clearly indicating that the parser didn't understand my intentions. So what to do?

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.