Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Generate start and end based on input

  1. #1
    Join Date
    Mar 2013
    Posts
    148

    Default Generate start and end based on input

    I have number of count values like

    Input :
    1004
    55
    10

    Output has to be in below format :
    count start end
    1004 0 100
    1004 101 200
    1004 201 300
    1004 301 400
    1004 401 500
    1004 501 600
    1004 601 700
    1004 701 800
    1004 801 900
    1004 901 1000
    1004 1001 1004
    55 0 55
    10 0 10

    How to generate start and end values using PDI. Any suggestions how can we do it.
    Last edited by pentaho2013; 12-14-2014 at 01:14 AM.

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

    Default

    You can use step "Calculator" for all the necessary calculations, but I would prefer step "User Defined Java Expression".
    Also step "Clone Row" would be part of my design.
    BTW: There seems to be no rationale behind a start value 0.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Mar 2013
    Posts
    148

    Default

    If possible can you share your ktr please

    Quote Originally Posted by marabu View Post
    You can use step "Calculator" for all the necessary calculations, but I would prefer step "User Defined Java Expression".
    Also step "Clone Row" would be part of my design.
    BTW: There seems to be no rationale behind a start value 0.

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.