Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: database

  1. #1

    Question database

    I've two database: data_header and data_details; the first database contains the détails of the second

    I want to extract data from the two database;
    this is an example:
    data_header:
    A : clé primaire B C a1 b1 c1 a2 b2 c2 data_details:
    T : clé primaire F J t1 a1 j1 t2 a1 j2 t3 a2 j3 t4 a2 j4
    the result :
    t1 a1 j1 b1 c1 t2 a1 j2 b1 c1 t3 a2 j3 b2 c2 t4 a2 j4 b2 c2
    thanks for your help

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

    Default

    Have a look at database join e.g.

    Regards,
    Sven

  3. #3

    Default

    please can you give me an example, I tested it but without result
    !!

    and thank you very much
    Regards,
    chaddou2010

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

    Default

    Play a little with it... it's hard to give an example that you run as you require a database. You can run whatever query you want in the database join and you can use parameters from your input row, the result will be attached to the end of your row.

    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.