Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Rename column names in table output

  1. #1
    Join Date
    Jul 2009
    Posts
    7

    Default Rename column names in table output

    Hi,

    I am using Spoon 3.1.0. to design a transformation which contains a Table Input to a file output. I would like to change a name in "Fields" tab from "qty" to "#qty". Is there a way to accomplish this? I don't want to modify the table input.

    Thanks in advance.

    Nick

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi Nick,

    You can use the "Select Values" step to rename your fields just before writing them to the file. I prepared a sample in Kettle 3.2, I am not sure whether it will work in 3.1, but my guess is that it will work alright, since the used steps are quite basic.

    Cheers

    Slawo
    Attached Files Attached Files

  3. #3
    Join Date
    Jul 2009
    Posts
    7

    Default

    Slawo,

    Thanks for your help. It works well.

    Regards,

    Nick

  4. #4
    Join Date
    Jun 2010
    Posts
    114

    Default

    You can refer to the link below for more details
    http://forums.pentaho.org/showthread.php?t=77409

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.