After using distinct, duplication in date field

[#1]

Hi All

In the attached application though I wrote the script to take only the distinct values for 'date' field it is giving lots of duplicate values. Apart from the repeatation of dates there are also issues as given below.

Also if I select From Date and To Date it is giving one date lesser than what I have selected.

For example:

If I select 30/05/2011 in the From Date and 03/06/2011 in the End Date, It selects the date from 30/05/2011 to 02/06/2011

Apart from this there may be some other issues as well. But firstly would like to solve above 2 issues.

Can some one please help me out on this please.

[rahulgupta]

Hey Hi,

Can you please reload this application as i have done some changes in the script.

After checking, let me know if you got the desired output or not.

Regards

[#3]

Hi Rahul

Thanks for your effort. But after reloading the data it is throwing the below error. Could you please check and let me know whats the problem is?

Field not found - <date>
LOAD
 date(40688 + rowno() - 1) AS Date,
 year(40688 + rowno() - 1) AS Year,
 month(40688 + rowno() - 1) AS Month
AUTOGENERATE vMaxDate - vMinDate + 1

[#4]

Hi Rahul

Attached the excel sheet which I am using it. Hope you can reload it to get to know the problem.

[rahulgupta]

Hello,

PFA

Check out this and let me know any issues.

Regards.

[#6]

Hi Rahul

Thanks!

But still the problem exists. As I told the thing is that in the report that date field in the group should contain all the dates. There shouln't be any breakage of dates. Though the duplicates has been avoided. It is not displaying all the dates. Even the dates which is not there in between Start Date and End Date. Hope it is understandable now. If any doubts please let me know.

[deepakk]

hi Attitude,

try the attach application

Deepak