Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Matching two Excel Files with two or more keys

  1. #1
    Join Date
    Nov 2015
    Posts
    2

    Default Matching two Excel Files with two or more keys

    Hi Experts,

    I am trying to match two excel files using two columns keys.

    Excel 1
    Col1,Col2,Col3,Col4
    Bnc,Ban345,12345,US
    Yv2,Cor501,543,IND

    Excel 1
    Col1,Col2,Col3
    Bnc,Ban345,12340
    Yv2,Cor501,544

    The keys are Col1 and Col2.
    If both columns match we need to insert a entry in a new excel with columns from both excels and the Col3 difference.
    Tried merge diff and stream lookup but we could not achieve the desired results.
    When we used stream lookup,only data from one file was getting written to the output file.
    Any help will be deeply appreciated

    Thanks,
    Ram

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Stream lookup seems the correct solution.
    Why did it not work?
    -- Mick --

  3. #3
    Join Date
    Nov 2015
    Posts
    2

    Default

    Thanks for your time.It worked when i rebuilt the whole thing.Trim might have been the issue.

Tags for this Thread

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.