Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: How to compare two rows of didfferent tables in kettel tool

  1. #1
    Join Date
    May 2013
    Posts
    4

    Default How to compare two rows of didfferent tables in kettel tool

    Hi All,

    I am getteing a problem like how to compare two rows of different tables in kettle tool...
    i mean i have a id colunm in first table and testid column in second table... now i want check id columns values are exist in testid column of second table

    how it vill be possible throw kettle tool ...pls help me

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    There are probably several ways to do this. One step you might look at is the Database lookup step, located under the "Lookup" folder in the Design tab. Here is the documentation for that step: http://wiki.pentaho.com/display/EAI/Database+lookup.

  3. #3
    Join Date
    Apr 2013
    Posts
    4

    Default

    Stream lookup

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    With a Diff step (Merge Rows (diff) from Join category) you must arrange the fields to compare in the field tables.
    Input rows must be sorted according to the selected field sets.
    So long, and thanks for all the fish.

  5. #5
    Join Date
    May 2013
    Posts
    4

    Default

    Thanks

  6. #6
    Join Date
    May 2013
    Posts
    4

    Default

    userID--- ansID - objid-- testype --- Date------ attempt
    1 --- 1234 --- 1 --- ConceptTest ---- 1/12/2013 12:12:01----- 1
    1 ---- 123445-- - 1 ---- ConceptTest---- 1/12/2013 12:12:01 ----- 1
    1---- 123445 -----1 ----- ConceptTest ----- 1/12/2013 12:12:02----- 2
    1----- 123445 --- 2 ---- ConceptTest----- 1/12/2013 12:12:02---- 1
    2 ---- 123445---- 2---- ConceptTest ------1/12/2013 12:12:02---- 1
    2 -----2456----- 2---- ConceptTest------ 1/12/2013 12:12:03----- 2

    for the above requirement i can get userid objid testtype and date, i want calculate attempt count.
    condition is when userid objid testtype and date is same then attempt is 1 else increment by 1.
    if any one have value is changed in userid objid testtype and date attempt is again 1 .

    Please any one help me....

  7. #7
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    The step you need is named "Add value fields changing sequence".
    So long, and thanks for all the fish.

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.