Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Joining 2 excel files

  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Default Joining 2 excel files

    Hi,
    I have one criteria input file which cotains the customerNames only and I have the main file which has 20 fields and one of them is the Cust_Name.

    I want to output all those rows only, to an excel file where the CustomerNames from the input file doesnt exist or match in the main file.

    I tried using Merge Rows but it doesnt work as both the files doesnt have the same no of fields. I am attching both the files along with this message.

    Could u pls help me.

    Thanks,
    Gyana
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2007
    Posts
    9

    Default an exemple

    HI,
    you find an exemple to answer your problem in the zip's file ...

    best regard.
    prec.
    Attached Files Attached Files

  3. #3
    Join Date
    Apr 2007
    Posts
    2

    Default

    Hi Prec,
    Thanku sooo much for ur help.

    Its really gr8 for Kettle users to know we have such awsome support from the members of this forum.

    I will really look forward to such support in future.

    Thanks & Regards,
    Gyana

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.