Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to extract values followed by zero

  1. #1

    Wink How to extract values followed by zero

    Hi,
    I'm new on this forum. i'm a beginner on Kettle.
    I'm searching how to read a tabel ansd to extract only values followed by a zero.
    For example if my table contains :
    0.2
    0.5
    2.4
    0
    1.4
    3.6
    0
    3

    The new table should contain :
    2.4
    3.6

    I've have been searching in Kettle without success.
    Thank youi.
    Christian

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

    Default

    The only ways I see is either via database analytics (outside of PDI) or via a javascript step... copying the data and making rows of current and previous data values, and the selecting rows via Select Values the rows which have 0 as previous value.

    Regards,
    Sven

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.