7 Replies Latest reply: May 2, 2018 3:44 PM by Sunny Talwar RSS

    How to use a table as a parameter

    Raphael Pavan

      Guys and Girls, I've done my queries to generate a table with some Commercial Establishments (CE) and now I'd like to search for information in another data base using these commercial establishments as parameters of where clause.

       

      For example, in my query I get the CE_number 's (100, 101, 102, 103) and I would like to search for

       

      load

      * Resident [Table_x] where EC_number in (100, 101, 102, 103)

       

      but I don't really know the CE_number 's, just have them in another table column generated previously.

       

      So, I would like to do something like this:

       

      load

      * Resident [Table_x] where EC_number in (load EC_number from [Table_y])

       

      Table_y can be a Qlik table, a QVD or a impala database.

       

      Is it possible? Didn't find any information about it,