Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
i have a set of data( Ticket and date);
example data set:
ticket date
100 9/10/2015
100 10/10/2015
100 11/10/2015
101 10/10/2015
so i want to get the min date associated to every ticket ie:
ticket date
100 9/10/2015
101 10/10/2015
could you please help me get the same.
Regards
Mythili
Hi
First convert your date string into a qv Date
T1:
LOAD ticket,Date(Date#(date,'DD/MM/YYYY'),'DD/MM/YYYY') as date Inline
[
ticket,date
100,9/10/2015
100,10/10/2015
100,11/10/2015
101,10/10/2015
];
in the front end
create a straight table
use ticket as dimension
use min(dates) as expression
hth
Sasi
Hello All,
thanks for the help so far, but just to make things clear: the script that i ma using is:
CompletedTemp:
LOAD Distinct
TICKET ,
Date( Makedate(Right(DATE,4),Mid(DATE,4,2),Left(DATE,2)),'DD-MM-YYYY') as DATE1
FROM
$(vQVD)\DAILY_TICKETS_RUNNING.qvd (qvd)
Where STATUS='Completed'
;
STABILITY_TMP:
NOCONCATENATE
LOAD
Distinct
TICKET ,
DATE(MIN(DATE1)) AS date2
RESIDENT CompletedTemp
WHERE TICKET=TICKET
Group by TICKET;
EXIT SCRIPT;
I will then have to join to the table "STABILITY_TMP" the rest of the fields based on the unique combinations of "ticket" and "Date" fields.
Thanks to suggest.
Mythili
Hi,
Did you try as I have given the script? It is working for me.
If possible upload the sample file.