Qlik Sense Data Load Syntax Help - 'Where in' Clause + Select Subquery + Logical operator

Anonymous — Tue, 07 Nov 2017 14:51:14 GMT

Hi,

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!!

Sample Code

Table1:

LOAD *

FROM [lib://masterdata.qvd];

Vendor:

LOAD "Vendor Name"

FROM [lib://vendordata.xls];

CostCenter:

LOAD "Cost Center ID"

FROM [lib://costcenterdata.xls];

/// Need help with the syntax for the below code ////

Table 2:

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;

Thanks,

Rajesh

Re: Qlik Sense Data Load Syntax Help - 'Where in' Clause + Select Subquery + Logical operator

dwforest — Thu, 25 Apr 2019 17:53:12 GMT

This is a bit old, in case someone needs the answer:

//get vendors
Vendor:
LOAD "Vendor Name"
FROM [lib://vendordata.xls];

//get cost centers
CostCenter:
LOAD "Cost Center ID"
FROM [lib://costcenterdata.xls];

//load data with valid vendors and cost centers already loaded
Table1:
LOAD *
FROM [lib://masterdata.qvd];
where exists ([Vendor Name]) 
OR exists ([Cost Center ID]);

This assumes the fields Vendor Name and Cost Center ID are in masterdata and have the same field name.

topic Qlik Sense Data Load Syntax Help - 'Where in' Clause + Select Subquery + Logical operator in App Development

Qlik Sense Data Load Syntax Help - 'Where in' Clause + Select Subquery + Logical operator

Re: Qlik Sense Data Load Syntax Help - 'Where in' Clause + Select Subquery + Logical operator