Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: how can I take the first row of a stream?

  1. #1
    Join Date
    Oct 2011
    Posts
    10

    Default how can I take the first row of a stream?

    I have an Excel Input and that excel file contains information in the header row that I need to process individually. How can I filter only the first row? I see a component named "Identify last row in a stream", but I don't see something like "Identify first row in a stream"

    The point is that I need to read one column from header, the name of that column contains an important data to store it in a place without affect the rests of the row of the main flow of data.

    Thanks!!

  2. #2
    Join Date
    Feb 2009
    Posts
    321

    Default

    perhaps, you could create a sequence and filtering for the number 1? however this is very inefficient, because the sequence runs for every row

  3. #3
    Join Date
    Oct 2011
    Posts
    10

    Default

    I tought about that but it seems very inefficient as you say. I would use it as a last resource XD

  4. #4
    Join Date
    Feb 2009
    Posts
    321

    Default

    you have never asked for the performance... :P, let me think another option
    reggards

  5. #5
    Join Date
    Oct 2011
    Posts
    10

    Default

    Ok, thanks man!

    I'll think another option too.

  6. #6

    Default

    Quote Originally Posted by sbiky View Post
    How can I filter only the first row?
    The step is Statistics -> Sample rows.

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

    Default

    If you just want to process the header row, you can restrict the number of rows and turn off header processing.

    Name:  GetHeader.png
Views: 1826
Size:  21.6 KB
    So long, and thanks for all the fish.

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.