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
* 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:
* 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,
I wanted to take some EC's by their revenues and calculated some limits for them. If they were above or below the limits I created, I would take them into a table, right?
Now that I have finally resolved how to calculate the limits rightly, I need to take some extra informations about them in the database, but I can't just add those informations into my limits calculations.
The problem is: the database has billions of EC's and I want to make a fast query just to gather information about my 17k EC's that are off limits, right? So I wanted to use them as my where clause limitation.
As I need to run this every month, I want to know if there is a automatic way to do it instead of having to print all the 17k numbers and putting them into inlines or something like that.