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


    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


    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


    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.