Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Get previous row fields

  1. #1
    Join Date
    Mar 2008
    Posts
    101

    Default Get previous row fields

    Good afternoon,
    In 3.2, it appears that the step "Get previous row fields" was deprecated. Just curious why, and what step replaces this? I just wanted to do a simple SCD type 3 (i.e. current_field, old_field)
    Thank you,
    Peter

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The Analytic step supports both LAG by a configurable offset.
    That mean not just previous row (-1) but also the one before that (-2), etc.

    It also supports LEAD by a configurable offset, meaning you can get the next row (+1) or the row before that (+2), etc.

  3. #3
    Join Date
    Mar 2008
    Posts
    101

    Default

    Matt, thanks for the fast reply, I will look at the Analyic Query step.

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.