Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to Import a CSV file Data into multiple tables

  1. #1

    Post How to Import a CSV file Data into multiple tables

    Hi,

    I'm having a CSV file containing data.I want to import that data from a single CSV file into multiple tables that resides in a same database of MySQL.

    Plz do the favour.

    Thanks,
    LakshmiNarayanan

  2. #2

    Default

    What is your problem with that?

    1. Create a CSV input step
    2. Create table output step
    3. repeat 2. until you have "enough" tables
    4. connect the CSV step with each table output step - and if asked say you want to copy the data (not distribute)

    Other questions?

  3. #3

    Default

    Quote Originally Posted by christophWeißenborn View Post
    What is your problem with that?
    Laziness I would think
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

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.