I am looking to load the data in Qlik Sense using a where clause from multiple temp tables that are loaded in the same code. Below is sample Psuedo code that looking to implement. Please suggest the right syntax and other better ways to load the data. Thanks a lot in advance for the help!!
LOAD "Vendor Name"
LOAD "Cost Center ID"
/// Need help with the syntax for the below code ////
Load * Resident Table 1
where exists (select [Vendor Name] from Resident Vendor) OR exists (select [Cost Center ID] from Resident CostCenter );
Drop Table Table1,Vendor, CostCenter;