Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

fetch the max time stamp of data

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

1 Solution

Accepted Solutions
Kushal_Chawda

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

4 Replies
el_aprendiz111
Specialist
Specialist

Hi,

You have a sample of data

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Kushal_Chawda

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
Not applicable
Author

Thank you guys...