Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: lookup component

  1. #1
    Join Date
    Oct 2012
    Posts
    116

    Default lookup component

    Hello.
    I would like to know, if there is a component which can compare data from database with data in a created table.

    For example.

    In PRD I have a table like this.
    group weight height age
    1 <80 <=50 <20
    2 >60 >40 >30

    And now I am loading data from a database (posgresql) and I want to put them into group where they belong.

    If I load this:
    weight height age
    90 50 35
    It should match the group "1" to this column.

    I have made a solution via Open Formula in PRD but I dont find this solution elegant.

    Thanks

  2. #2

    Default

    If you are doing a static table, one that's not stored in the database, you aren't going to have a very elegant solution period. However, you can always try something like a CTE.

    Code:
    WITH STATIC_TABLE (GROUP, WEIGHT, HEIGHT, AGE) AS (
    VALUES
    (1,80,50,20),
    (2,60,40,30)
    )
    From there you can then use the CTE table just like any other table.

    However, you are not going to find a really great solution when you deal with tables that aren't in your database. We have a few things just like this as well and ultimately they are just stop gap solutions until we get a web interface up so that customers can edit the values themselves.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    I don't work for Pentaho, but I like their stuff.

    Justin Barrett
    This sig may be my last!

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.