Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Two excel sheets match and update

  1. #1
    Join Date
    Jul 2017
    Posts
    5

    Default Two excel sheets match and update

    Hi, sorry for the newbie questions in advance.
    I have 2 spread sheets, sheet1 ColumnA is the key field, sheet2 ColumnA is key field, but in sheet2 if there is a match i need to update Column B in sheet2 with a value of "Matched", if not matched Column B value should be "Not Matched.

    Any help is GREATLY appreciated!

    Thank you!

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

    Default

    You can write a whole sheet, but you can't update columns or cells in a sheet.

    So, you would use one transformation to read and join the rows from both sheets, eventually emitting the rows you want see later in your second sheet using Copy-Rows-To-Result.
    Another transformation can then read the result rows and rewrite the second sheet.
    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.