Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Concat CSV + MySql

  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Default Concat CSV + MySql

    Hi,

    how to concat a csv file with mysql database? For example

    CSV:

    name surname info
    john;donn;abc
    carl;carl;ggg

    MYSQL:
    my_name my_surname my_info
    rob matt ddd
    tom ron www

    out file:
    n s i
    john donn abc
    carl carl ggg
    rob matt ddd
    tom ron www

    Regards

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    If you just want to unite the rows from CSV and Table Input, let Text File Output handle this by enabling option Append on the Content tab.
    So long, and thanks for all the fish.

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.