topic Re: SQL Load help in QlikView

SQL Load help

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the below load statement and I would like to only bring in the latest date (ARDate) for each Voucher.

LOAD UserID,
Date as ARDate,
Voucher,
Status,
Action as ARAction
FROM

(biff, embedded labels, table is [Action Summary$]);

For example if I have the below, I only want to bring in the last line:

ARDate Voucher ARAction

08/03/2017 1234-1 Contact ABC

09/03/2017 1234-1 Contact BCD

10/03/2017 1234-1 Contact CDE

Hope the above makes sense.

Regards,

Daniel

Re: SQL Load help

sunny_talwar — Fri, 10 Mar 2017 13:17:19 GMT

May be do this

Table:

LOAD UserID,
Date as ARDate,
Voucher,
Status,
Action as ARAction
FROM

(biff, embedded labels, table is [Action Summary$]);

Right Join (Table)

LOAD Voucher,

Max(ARDate) as ARDate

Resident Table

Group By Voucher;

Re: SQL Load help

vinieme12 — Fri, 10 Mar 2017 13:21:57 GMT

Hi Sunny, do you think Right Keep, will perform better?

Re: SQL Load help

sunny_talwar — Fri, 10 Mar 2017 13:26:03 GMT

Between the two, I don't think Keep or Join should be different.... but can be tested out. I think the best technique would be to use Peek/Previous if the data is well sorted. By well sorted I mean, the data is sorted first by Voucher and then by descending order of date