Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Generate

  1. #1
    Join Date
    Mar 2013
    Posts
    148

    Default Generate

    How to generate columns dynamically?

    For Example if i have my input csv file with the below structure

    Entity, Table, Type, Pos, Name

    output table structure should look like below. but i dont know how many times it has to generate same column names. Suppose if i wanted to get three times it has repeated dynamically then it has to generate same columns thrice like below.

    Entity, Table, Type, Pos, Name, Entity_1, Table_1, Type_1, Pos_1, Name_1, Entity_2, Table_2, Type_2, Pos_2, Name_2,Entity_3, Table_3, Type_3, Pos_3, Name_3

    One more thing i am looking like above scenario is if i know entity and Table columns are coming as input and for the output if i wanted to generate 5times for Entity i.e Entity,Entity_1,Entity_2,Entity_3,Entity_4 and Table column has to be repeated 2times i.e Table, Table_1

    Any suggestions?
    Last edited by pentaho2013; 02-02-2014 at 02:52 AM.

  2. #2
    Join Date
    Mar 2013
    Posts
    148

    Default

    Any suggestions?

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.