Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Hi,
You have a sample of data
Why not to use preceding load like Load *, Max(Time Stamp) Group By [Time Stamp] ??
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;
Thank you guys...