How to pickup only last record per user distinct load

[vikasmahajan]

Dear all

I have following type of data user wise

So  in QV load i want to show only single last row per user.

Thanks

Vikas

[vikasmahajan]

Actually user wise i want to create a list for last updated record for above case

E007569

Hecker,Jill Marie (E007569)

R295607

Praneet Jayaram

Terminated

201605

will be the o/p  which is most recent record for this user.

Thanks

Vikas

[vikasmahajan]

This is only one user details i have so many users , per user i want to pickup only last updated record.

Vikas

[Anonymous]

Hi Vikas,

Have you tried with Max(charge_month) ?

[tamilarasu · Accepted solution]

Try this,

Data:
LOAD user_sid,
     User_Name,
     [Manager SID],
     [Direct Manager],
     [Status in ID Vault],
     charge_month
FROM
[Book1 (1).xlsx]
(ooxml, embedded labels, table is Sheet1);

Inner Join(Data)
Load  user_sid,
     Max(charge_month) as charge_month
Resident Data
Group By user_sid;

[MindaugasBacius]

Try to use LastValue statement.

[vikasmahajan]

yes