Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Auto increment data based on column

  1. #1
    Join Date
    Aug 2015
    Posts
    313

    Default Auto increment data based on column

    Hi Sir,Madam,

    PDI 6.1, JAVA 1.7, MySQL DB.
    I want to add my sample transformation and my sample excel file to explain in-detailed about my logic but PDI forum is not allowing me to add any objects. Sorry for that. below is my excel data.

    PRODUCT DESCRIPTION UNITS
    F00001 added 350
    I need to generate rows 350 times based on UNITS column.

    example: While generating the 350 rows PRODUCT column data i.e. should start fromF00001 and end with value F0000350 that means, record should auto increment based on UNITS column. I am able to generate 350 rows using Clone row step but not able to increment the value. Could you please help on this scenario.

    expected output :

    PRODUCT DESCRIPTION UNITS
    F00001 added 350
    F00002 added 350
    F00003 added 350
    F00004 added 350
    F00005 added 350
    F00006 added 350
    .
    .
    .
    F0000350 added 350
    Thanks,
    Santhi

  2. #2
    Join Date
    May 2016
    Posts
    282

    Default

    You have two different examples of adding a sequence in your samples folder in the Pentaho installation path.
    Regards
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

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.