Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: equivalence between MQL and SQL

  1. #1

    Default equivalence between MQL and SQL

    Hi everybody!

    I would like to know if it exists an equivalence between MQL and SQL for the clause "IN".
    For exemple, i would like to write in MQL the following SQL query :
    Select * from table where column1 IN (value1, value2, ...).

    What is the syntaxe for the "IN" condition in MQL?

    Thank you for your answers.

    Jonathan

  2. #2

    Default Sorry for my post

    I found a Wiki with the pentaho Metadata Formulas!
    If someone wants to know, the answer is :
    IN([column1];value1,value2,...)

    ++

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.