Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: inserting different columns values in same table and same column in

  1. #1
    Join Date
    Jan 2018
    Posts
    13

    Default inserting different columns values in same table and same column in

    I want to create transformation in which I want to add multiple inputs table column value into one table in the same column.
    e.g
    Two input products table having id and name and one output table with id and column wants to add all values of both in output table

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    If all the input tables are in the same database, you can just use a Table Input followed by a Table Output.
    In the Input step write a SELECT statement including all the input data from the different tables.

Tags for this Thread

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.