Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: ways to combine multiple tables into unified header field names

  1. #1
    Join Date
    Sep 2014
    Posts
    15

    Default ways to combine multiple tables into unified header field names

    Hello, I have an Access data base with a few different, unrelated tables. What's the best transformation to bring all of those into a unified CSV output with mapped field names?

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

    Default

    A straight forward solution would be to use an Access-Input step for each table using the appropriate CSV fieldnames for the table columns.
    Then all the Access-Input steps can hop to the same Text-File-Output without much further configuration besides an output filename.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Sep 2014
    Posts
    15

    Default

    thanks marabu

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.