Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to find the same query but in qlik sense. how to do?
select CustomerID, CompanyName
from customers as a
where exists
(
select * from orders as b
where a.CustomerID = b.CustomerID
and ShipCountry = 'UK'
);
@Labras14 First you need to create QVDs for both tables. Then use those QVDs to build logic in Qlik
Orders:
LOAD distinct CustomerID
FROM Orders.QVD
where ShipCountry ='UK';
Left join(Orders)
LOAD CustomerID,
CompanyName
FROM Customers.QVD;
@Labras14 First you need to create QVDs for both tables. Then use those QVDs to build logic in Qlik
Orders:
LOAD distinct CustomerID
FROM Orders.QVD
where ShipCountry ='UK';
Left join(Orders)
LOAD CustomerID,
CompanyName
FROM Customers.QVD;
Thanks a loot!
You save my life in this moment!
@Labras14 Just changed the join type in previous post