Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Im quite new in Qlikview and i have a simple inner join SQL script below:
How do i put this SQL inside Qlikview using OLEDB connection?
select a.customer, a.Operator, Date
From dbo.customer a
Inner Join
( Select customer, Operator, Min (Date) as Firsttransaction From dbo.customer
Group by customer, Operator) b
on a.customer = b.customer and a.Date = b.Firsttransaction
Thanks
Mazda
In your load script you can have this:
LIB CONNECT TO 'SQLDB';
SQL
select a.customer, a.Operator, Date
From dbo.customer a
Inner Join
( Select customer, Operator, Min (Date) as Firsttransaction From dbo.customer
Group by customer, Operator) b
on a.customer = b.customer and a.Date = b.Firsttransaction
;
Have you pulled tables from SQl...?
if it like
Table1:
Load *
From dbo.customer;
inner join
Table2:
Load *
From dbo.Operator;
In your load script you can have this:
LIB CONNECT TO 'SQLDB';
SQL
select a.customer, a.Operator, Date
From dbo.customer a
Inner Join
( Select customer, Operator, Min (Date) as Firsttransaction From dbo.customer
Group by customer, Operator) b
on a.customer = b.customer and a.Date = b.Firsttransaction
;
Thanks Petter!