Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: MongoDB Input with param of other input

  1. #1

    Default MongoDB Input with param of other input

    I'm have two inputs some one on MySql database and other on MongoDb, I kind of sample input. With results of mysql select I want to select some data on mongo, but when I try to use the result of mysql as parameter on mongo I receive this message: "Query contains unresolved variables or field substitutions" I'm doing this query on Mongo Input:
    HTML Code:
    {${field}: {"${exists}": true}}
    The field is listed on input fields on mongodb input, and I'm try to use "?" instead ${field}, but get "Sorry, no rows found to be previewed."

    By the way I'm using 7.1 version.
    Thanks for your attention.
    Last edited by williamespindola; 11-06-2017 at 08:14 PM.

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

    Default

    Both input steps are in the same transformation?

    You can't set and get a variable value in the same transformation.
    So long, and thanks for all the fish.

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.