Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Import of CSV triggered by a special line

  1. #1
    Join Date
    Sep 2007
    Posts
    7

    Default Import of CSV triggered by a special line

    Hello,
    Our ERP exports results into tab separated files. I need to import these files into SQL server to further process them.
    If a line contains the name of a table, it means the lines following it is the contents of that table. Two empty lines means we have reached the end of that table. Example:

    TableX
    2001
    2002
    2003
    2006
    newLine
    newLine
    TableY
    ....
    Is it possible to detect such data using Kettle?

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

    Default

    No....

    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.