Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: "Rows to Columns" Implementation Question.

  1. #1

    Default "Rows to Columns" Implementation Question.

    Hello,

    I'm trying to implement "Rows to Cols".

    i got a text file, like this
    --------------------------------
    ^[Start]
    ^[field1] field_value_1
    ^[fileld2] field_value_2
    ^[End]
    ^[Start]
    .
    .
    ^[End]
    ^[Start]
    .
    .
    ^[End]
    ------------------------------

    i want to store data from text to DB table
    here is table schema.

    MyDATA (filed1, filed2)

    so, I'm looking for "rows to cols" implementation.

    how can I do ??

    Thanks.

    warwithin.

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

    Default

    Not... pre-process the file by something else perl, vbscript, ... to make it into a proper "csv" file.

    It still amazes me from time to time that designers/developers would choose such awkward output formats... in your case almost xml, but not just yet.

    Regards,
    Sven

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.