Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: excel output rows written as retval?

  1. #1
    Join Date
    Feb 2009
    Posts
    12

    Default excel output rows written as retval?

    hello,

    i write data into an excel file and in the next transformation i want to write the number of rows into a database table. how can i do this?

    thank you for your help!!

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

    Default

    Branch of the stream you use to write to excel... on the branched of hop use something like group by to count the rows... or just add a sequence, skip all rows except the last (blocking step or last step) and you got your number of rows.

    Regards,
    Sven

  3. #3
    Join Date
    Feb 2009
    Posts
    12

    Default

    thanks for your help. but where do i have to set the branch??? after the excel output or before?

  4. #4
    Join Date
    Feb 2009
    Posts
    12

    Default i did it gg

    thanx again.

    i made a second hop from the table input to an add sequence step, then blocking step and after that i set the variable number_of_rows!!


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.