Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find the attached QVW and QVD.
When i filter the date field in the Load Script, I am getting some 225 records but there are actually 625 records.
Can someone please check the Qvw.
Thanks in advance.
Regards,
Keerthi KS
Hi,
It seems there are 4 different timestamp formats (with single space,double space) in the qvd. first convert it, then check.
Alt(Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'),
Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'),
Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'),
Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'))) as New
Edit
Sample Attached
It's all the double spaces. Try replacing the double spaces with single spaces:
TimeStamp(TimeStamp#(Replace(LastModifiedOn,' ',' '), 'MMM D YYYY h:mmTT'))
When i load complete data and check it was around 625 where the dates are greater than 13 Feb 2016.
why this condition
it gives u the the date > than records only i think
Where Timestamp#(LastModifiedOn, 'MMM D YYYY hh:mmTT')
>Timestamp#('13/2/2016', 'DD/M/YYYY');
Yes i need only records that are greater than 13/2/2016.
But its not giving correct data.
Hi,
It seems there are 4 different timestamp formats (with single space,double space) in the qvd. first convert it, then check.
Alt(Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'),
Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'),
Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'),
Date#(LastModifiedOn,'MMM DD YYYY hh:mmTT'))) as New
Edit
Sample Attached
Please find the attached qvw. I Have selected the data and it shows only 626 records
You can try,
LOAD LastModifiedBy,
LastModifiedOn,
Uniqueid
FROM
(qvd) Where Date(Floor(TimeStamp#(Replace(LastModifiedOn,' ',' '), 'MMM D YYYY hh:mmTT')), 'DD/MM/YYYY') > '13/02/2016' ;
but chk this..
try
WHERE Date(Floor(TimeStamp#(purgechar(LastModifiedOn,' '), 'MMMDDYYYYhh:mmTT')), 'DD/MM/YYYY') > date#('13/02/2016' ,'DD/MM/YYYY');