Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Balance Sheet

  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Default Balance Sheet

    Hi ,I need to import txt file in MySQL.
    Text file is Balance Sheet with 100+ company in format:
    COMPANY
    ADDRESS
    CITY
    ------------------------------------------------------------------------
    CURRENT ASSETS 22222 11111
    SHORT THERM 2222 1111
    etc.
    There is same number of rows for each company balance sheet t.
    Is there any option in the PDI 3.1.0 to transform data in format :
    COMPANY ADDRESS CITY CURRENT ASSETS 22222 11111
    COMPANY ADDRESS CITY SHORT THERM 2222 1111
    or script is way to go?


    TIA
    Sasha

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

    Default

    If you throw enough time and money at it, the sky is the limit

    Problems with your file:
    - For PDI each line needs to be of the same format... you could e.g. do 1 run and extract the company details, and then another run (using a big header, assuming the company details are always on the same number of lines)...
    - you data is not very seperated, if you don't need to process it you could extract 1 line as a single field

    Alternatively 1 text file input reading 1 line in 1 field and a pretty complex javascript step would also do the trick.

    So in short, it's possible but with a lot of work-arounds ... so maybe a small and nice script is better.

    Regards,
    Sven

  3. #3
    Join Date
    Jun 2008
    Posts
    2

    Default

    Thanks Sven for your reply.


    Pythoooooooon!!!
    Come here you lazy snake, we have work to do!

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.