Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to use variable in Database Lookup

  1. #1

    Default How to use variable in Database Lookup

    Hi,

    Is it possible to use the variable in Field1 in Database Lookup step? Like in below pic. I got the error cannot resolve the variable when I run it.

    Thank you.

    Name:  Screen Shot 2015-11-02 at 9.57.36 am.png
Views: 107
Size:  15.2 KB

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

    Default

    You can't use variable expressions to specify fieldnames in Database-Lookup.
    Your variables would keep their values between rows, anyway.
    Just replace your Database-Lookup by a Stream-Lookup fed by a Table-Input.
    You can use your variables in the SELECT statement of that Table-Input step, then.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2015
    Posts
    5

    Default

    Another way is to use getVariables step. Create new fields in get variables step and assign the variables. Now use the new fields in the database lookup.
    Bhaskar's Website

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.