Solved: fetch the max time stamp of data - Qlik Community

Anonymous · ‎2017-05-26

Hi,

I have Six number of file are their .In that file are same name of duplicate names but in different time stamp , so I need to fetch only max time stamp of data for every duplicate file other one have to be removed

could any one help me out from this

Regards,

Vijay.M

Kushal_Chawda · ‎2017-05-27

Data:

LOAD Name,

Filebasename() as FileName,

Timestamp(TimeStamp,'DD/MM/YYYY hh:mm:ss') as TimeStamp

FROM Files;

inner join(Data)

LOAD Name,

FileName,

Timestamp(max(TimeStamp),'DD/MM/YYYY hh:mm:ss') as TimeStamp

Resident Data

Group by

Name,

FileName;

View solution in original post

el_aprendiz111 · ‎2017-05-26

Hi,

You have a sample of data

Anil_Babu_Samineni · ‎2017-05-26

Why not to use preceding load like Load *, Max(Time Stamp) Group By [Time Stamp] ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Kushal_Chawda · ‎2017-05-27

Data:

LOAD Name,

Filebasename() as FileName,

Timestamp(TimeStamp,'DD/MM/YYYY hh:mm:ss') as TimeStamp

FROM Files;

inner join(Data)

LOAD Name,

FileName,

Timestamp(max(TimeStamp),'DD/MM/YYYY hh:mm:ss') as TimeStamp

Resident Data

Group by

Name,

FileName;

Anonymous · ‎2017-05-29

Thank you guys...