Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Help with processing this data stream

  1. #1
    Join Date
    Mar 2009
    Posts
    8

    Default Help with processing this data stream

    Here's the situation. I've got a spreadsheet I'm trying to process where the first column is sparsely populated. For example....

    Last Name First Name
    Greaves Greg
    Donna
    Grant
    Smith Rick
    John
    Shaw Ron

    I need to turn this into a stream that looks like this:

    Last Name First Name
    Greaves Greg
    Greaves Donna
    Greaves Grant
    Smith Rick
    Smith John
    Shaw Ron

    I've been trying the analytic query but it needs to look back a varying number of rows (-1 for the second row, -2 for the third). Any ideas on how to approach this problem

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Use the Text File input, and select the Repeat option.

    EDIT: Re-read, where you said spreadsheet. Assuming that this is Excel, use the Excel input, and select the Repeat option.
    Last edited by gutlez; 08-27-2012 at 12:27 PM.

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

    Default

    Just in case Donna comes with the lastname column...
    Attached Files Attached Files
    So long, and thanks for all the fish.

  4. #4
    Join Date
    Mar 2009
    Posts
    8

    Default

    Thanks. This is just what I needed. Really simplifies things.

    Quote Originally Posted by gutlez View Post
    Use the Text File input, and select the Repeat option.

    EDIT: Re-read, where you said spreadsheet. Assuming that this is Excel, use the Excel input, and select the Repeat option.

Tags for this Thread

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.