Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: kettle - changing column names between input and output tables

  1. #1
    Join Date
    Nov 2015
    Posts
    6

    Default kettle - changing column names between input and output tables

    Hi - kettle/spoon

    My input table has a field (physical/virtual)

    My output table (postgres)does not like dashes so it has a correponding (physicalVirtual) field.

    How do I use spoon to map the old column name with the new column name.

    Thx.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Select Values step!
    -- Mick --

  3. #3
    Join Date
    Nov 2015
    Posts
    6

    Default

    Perfect - thanks!

    (I'm not sure if one marks questions as answered in this forum)

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

    Default

    Actually, the Table-Output step supports field mapping by itself ...
    So long, and thanks for all the fish.

  5. #5
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Actually, the Table-Output step supports field mapping by itself
    ehmm... yes, that's another option
    -- Mick --

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.