Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to dislay always the last updates from an excel files. Please find the files attached,
scenario :
•Take the latest timestamp data for the month e.g. 28th March
•Exclude any data with in blank from Development
I tried already the max and firstsortedvalue but I can't display only the last updates.
Can someone advice me?
I want to display only this
Development | LGP | NGPF | G5b | G5F | BRNG | FCS | STD | FVB | OR | Comment | Timestamp |
First | G2 | Mar-18 | Sep-18 | Sep-18 | £300 | £250 | £100 | £50 | Green | test3 | 27/03/2018 12:04 |
Second | G3 | Mar-18 | Sep-18 | Sep-18 | £300 | £250 | £100 | £50 | 0 | test2 | 27/03/2018 12:04 |
Third | G1 | Mar-18 | Sep-18 | Sep-18 | £300 | £250 | £100 | £50 | 0 | test1 | 27/03/2018 12:04 |
Try this
Table:
LOAD Development,
LGP,
NGPF,
G5b,
G5F,
BRNG,
FCS,
STD,
FVB,
OR,
Comment,
Timestamp
FROM
[Test Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where Development > 0;
Right Join (Table)
LOAD Development,
Max(Timestamp) as Timestamp
Resident Table
Group By Development;
Try this
Table:
LOAD Development,
LGP,
NGPF,
G5b,
G5F,
BRNG,
FCS,
STD,
FVB,
OR,
Comment,
Timestamp
FROM
[Test Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where Development > 0;
Right Join (Table)
LOAD Development,
Max(Timestamp) as Timestamp
Resident Table
Group By Development;
Thanks for help, all good using your solution:)