Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Help on inter-row validation and processing

  1. #1
    Join Date
    Sep 2006
    Posts
    14

    Question Help on inter-row validation and processing

    I want to peform some inter-row validation and amend the value in certain fields when there are overlaps in the field value e.g.

    Original data:-

    Effective from Effective to Content
    20070101 20071231 Data1
    20070331 99991231 Data1

    I want to change the `Effective to` value for the 1st row to the value in the `Effective from` of the 2nd row minus 1 to derive the following:-

    Required data:-

    Effective from Effective to Content
    20070101 20070330 Data1
    20070331 99991231 Data1

    How can this be done in Kettle?

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

    Default

    inter row comparison/validation is pretty hard. Sometimes you can get away with some javascripting, but only under a lot of assumptions. No easy solutions for your question.

    Regards,
    Sven

  3. #3
    Join Date
    Sep 2006
    Posts
    14

    Default Help on inter-row validation and processing

    Tks for the response.

    Guess I'll to work outside Kettle to achieve this.

    Best Rgds

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.