Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Extracting Data along Relationships

  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Unhappy Extracting Data along Relationships

    I would like to know what the best way is to extract data from parent / child tables.
    Currently I reading my first table from the database, Table input.
    Feeding that to a Table Lookup using the flow from the Table Input
    and so on.

    What I can't get to work is another Table input rather than using he Table Lookup.
    Should I be able to put a where clause in and use the ? notation?
    I have not been able to get this to work. Have also tried to using the ${variabel} notation and have set a session variable, that does not work eaither.

    Help Please....

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

    Default

    You either want database lookup or database join. Table input can't do what you want it to do.

    Regards,
    Sven

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.