Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: execute specific query in after filter rows

  1. #1
    Join Date
    May 2013
    Posts
    1

    Default execute specific query in after filter rows

    Hi,
    In my diagram at a certain point, I have a filter rows. If the result is TRUE I would like to do a SELECT otherwise (FALSE) another kind of select. I did it with two table input objects.

    Actually, after the filter rows, both the two tableinput are executed may be because are initialized at the start. I've also tried with the SQL script but it seems to has the same behavior.

    How Can I do that?
    Thanks

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    both the two tableinput are executed may be because are initialized at the start
    There's no maybe.
    All steps within a transformation are initialised at the same time.

    I guess that you have to create a job with 2 transformations, one for each table input.
    Or at least I would try that.

    Mick

  3. #3
    Join Date
    May 2013
    Posts
    8

    Default

    Dear,
    Use a database join to get 2 values as output like true and false. and try using "Switch case" step.
    Thanks & Regards,
    Deepak

Tags for this Thread

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.