Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi EveryOne i have Column Cotaining Timestamp date field
21/4/2012 4:30:00AM
21/4/2012 5:30:00AM
21/4/2012 6:30:00AM
22/4/2012 4:30:00AM
22/4/2012 5:30:00AM
22/4/2012 6:30:00AM
22/4/2012 7:30:00AM
i want to get only
4:30AM
5:30AM
6:30AM
as a Column only once.. so can use as filter on dashboard..
If i am using Time(Timestampfield , ,'hh:mm[.fff] TT') ... so i am Getting as a multiple time
4:30AM
5:30AM
6:30AM
4:30AM
5:30AM
6:30AM
... I want like Month... when we fetch month from date field it given only Jan , Feb, Mar... still when multiple date for jan.
kinldy help me to get Time Column so that its shows only one for each time... so when user select say..4:30 AM... It fetch
21/4/2012 4:30:00AM
22/4/2012 4:30:00AM
Sample using your data.
Script:
Table:
LOAD *,
Time(Frac(TimeStamp#(TimeStampField, 'DD/M/YYYY h:mm:ssTT')), 'h:mmTT') as TimeField,
Date(Floor(TimeStamp#(TimeStampField, 'DD/M/YYYY h:mm:ssTT'))) as DateField;
LOAD * Inline [
TimeStampField
21/4/2012 4:30:00AM
21/4/2012 5:30:00AM
21/4/2012 6:30:00AM
22/4/2012 4:30:00AM
22/4/2012 5:30:00AM
22/4/2012 6:30:00AM
22/4/2012 7:30:00AM
];
Try it with Frac:
Time(Frac(TimeStamp#(TimeStampField, 'DD/M/YYYY h:mm:ssTT')), 'h:mmTT') as TimeField
Sample using your data.
Script:
Table:
LOAD *,
Time(Frac(TimeStamp#(TimeStampField, 'DD/M/YYYY h:mm:ssTT')), 'h:mmTT') as TimeField,
Date(Floor(TimeStamp#(TimeStampField, 'DD/M/YYYY h:mm:ssTT'))) as DateField;
LOAD * Inline [
TimeStampField
21/4/2012 4:30:00AM
21/4/2012 5:30:00AM
21/4/2012 6:30:00AM
22/4/2012 4:30:00AM
22/4/2012 5:30:00AM
22/4/2012 6:30:00AM
22/4/2012 7:30:00AM
];
Hi Sunny,
Thanks for Ur Reply ... Ur Script work for Inline But When i Load My QVD and Connecting with Calander ..Its not Happening as well Master Calander not able to Connect Correctly...Kinldy Help Me for the same.
Try the attached
Thankss Sunny for ur help ......