Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Picking up fields from various tables.

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Picking up fields from various tables.

    I am working on a test project and I need to pick up fields from different tables.

    SALES TABLE
    Products -- Units sold
    Product A -- 300
    Product B -- 500
    Product C -- 400
    Product D -- 300

    RETURNED UNITS TABLE
    Products -- Units returned
    Product A -- 30
    Product B -- 50
    Product C -- 40
    Product D -- 30

    I need to produce a table that looks like

    Products -- Units sold -- Units returned
    Product A -- 300 -- 30
    Product B -- 400 -- 40
    Product C -- 500 -- 50
    Product D -- 300 -- 30

    Something like this so that I can push the values into a calculator. Will this be possible?

  2. #2
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Picking up fields from various tables.

    Actually, I have 6 tables and I have to pick 1 field on each tables. If it is only one field, then I can do it with a look up table. But with this problem, is there anything more efficient?

    Thanks!

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.