Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: add constant from a parameter

  1. #1
    Join Date
    Aug 2014
    Posts
    24

    Default add constant from a parameter

    Hi,
    I have an input table that returns a set of columns, and before I do anything else with that result, I'd like to add a column with a value from a parameter (environment name). So, for instance, if my input table step returns:
    col1 col2 col3
    blu blk wht

    I'd like to make it into
    col1 col2 col3 env
    blu blk wht test

    I tried doing it by adding a "add constants" step, but it doesn't seem to perform a parameter substitution. I see that I can add a column with a javascript, but I'd rather not do it. what's the best way to handle this situation?

  2. #2
    Join Date
    Aug 2014
    Posts
    24

    Default

    ok, please ignore, found a solution. I used the "Get Variables" step.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by zevedtov View Post
    I used the "Get Variables" step.
    That was the correct way to do it.

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.