Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: insert rows

  1. #1
    Join Date
    Mar 2013
    Posts
    148

    Default insert rows

    Hi,

    How to add/insert multiple rows dynamically based on the source rows. For example intially i have two rows in data grid so i have inserted into excel that got inserted based on the below attachment. But now i have added four records in data gird then it has to adjust excel rows and insert in that. So the additional two records has to enter below 1 and 2 i.e before employee records it has to enter. So how could i handle it. Any suggestions please
    Attached Images Attached Images  

  2. #2
    Join Date
    Mar 2013
    Posts
    127

    Default

    Hi

    In microsoft excel output go to content tab and check option when writing rows shift existing cells down

    Regards,
    Mateen

  3. #3
    Join Date
    Mar 2013
    Posts
    148

    Default

    I should not do it manually .. Based on the rows it has to do that and fill that rows. These things has to be automated using ETL Tool

    Quote Originally Posted by MateenSA View Post
    Hi

    In microsoft excel output go to content tab and check option when writing rows shift existing cells down

    Regards,
    Mateen

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    I should not do it manually
    Have you tried what has been suggested?
    -- Mick --

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.