SQL Load help

[danielnevitt]

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

[sunny_talwar]

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;

[vinieme12]

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

[sunny_talwar]

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