Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Process the Column data in Excel File

  1. #1

    Default Process the Column data in Excel File

    We are receiving the data in excel file and need to insert into the database. Please find the input file format and the expected output.

    Could you please provide inputs and really helpful

    Input:
    TimeStamp FieldA FieldB
    2017-01-01T00:00 0.0 0.0
    2017-01-01T00:30 0.0 0.0
    2017-01-01T01:00 0.0 0.0
    2017-01-01T01:30 0.0 0.0
    2017-01-01T02:00 0.0 0.0
    2017-01-01T02:30 0.0 0.0
    2017-01-01T03:00 0.0 0.0
    2017-01-01T03:30 0.0 0.0
    2017-01-01T04:00 0.0 0.0
    2017-01-01T04:30 0.0 0.0
    2017-01-01T05:00 0.0 0.0
    2017-01-01T05:30 0.0 0.0
    2017-01-01T06:00 0.0 0.0
    2017-01-01T06:30 0.0 0.0


    Expected Output:


    FieldName TimeStamp Value
    FieldA 2017-01-01T00:00 0.0
    FieldA 2017-01-01T00:30 0.0
    FieldA 2017-01-01T01:00 0.0
    FieldA 2017-01-01T01:30 0.0
    FieldA 2017-01-01T02:00 0.0
    FieldA 2017-01-01T02:30 0.0
    FieldA 2017-01-01T03:00 0.0
    FieldA 2017-01-01T03:30 0.0
    FieldA 2017-01-01T04:00 0.0
    FieldA 2017-01-01T04:30 0.0
    FieldA 2017-01-01T05:00 0.0
    FieldA 2017-01-01T05:30 0.0
    FieldA 2017-01-01T06:00 0.0
    FieldA 2017-01-01T06:30 0.0
    FieldB 2017-01-01T00:00 0.0
    FieldB 2017-01-01T00:30 0.0
    FieldB 2017-01-01T01:00 0.0
    FieldB 2017-01-01T01:30 0.0
    FieldB 2017-01-01T02:00 0.0
    FieldB 2017-01-01T02:30 0.0
    FieldB 2017-01-01T03:00 0.0
    FieldB 2017-01-01T03:30 0.0
    FieldB 2017-01-01T04:00 0.0
    FieldB 2017-01-01T04:30 0.0
    FieldB 2017-01-01T05:00 0.0
    FieldB 2017-01-01T05:30 0.0
    FieldB 2017-01-01T06:00 0.0
    FieldB 2017-01-01T06:30 0.0

  2. #2

    Default

    I have used Row Normalizer and got the output as expected

  3. #3
    Join Date
    Aug 2016
    Posts
    239

    Default

    Classic ETL example. Well done.

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 - 2017 Pentaho Corporation. All Rights Reserved.