All records

[Anonymous]

Hi,

I need to get all recorsd

[Anonymous]

any help?

[tamilarasu · Accepted solution]

Hi John,

Try this,

CumulatvieDaily:

LOAD Reg,
[Date and Time],
Date,
[Cumulative Number]
FROM
[DailyCumulative Example.xlsx]
(ooxml, embedded labels, table is Sheet1);

Left Join (CumulatvieDaily)
Load Reg,
Date,
Max([Cumulative Number]) - Min([Cumulative Number]) as DailyRecords
Resident CumulatvieDaily
Group by Reg, Date;