date repeatation

[#1]

Hi all,

In the attached .QVF file. you have sheet with name "date".

where you can see the table which has dates. dates are repeated many times. i need each date only once.

Please help on it.

Thanks,

Pramod

[Gysbert_Wassenaar · Accepted solution]

I can't check your document right now, but check that your date values do not contain time fractions. If necessary use the floor function to cut of the time fractions:

MyTable:

LOAD ...some_fields...,

     date(floor(MyDateField),'M/D/YYYY') as MyDateField

FROM ....

[robert_mika]

Try:

LOAD Distinct

[santhoo_san]

change your date format. It has time stamps, if you remove time stamp from the date, you will get unique date in the list.

date(floor(CanonicalDate))

[#5]

Hi,

I checked i don't have timestamps for date fields.

Thanks,

Pramod

[santhoo_san]

Hi See the date stamp in your date field

[#7]

Hi,

You can see the attached image.

Thanks,

Pramod

[santhoo_san]

Hi Pramod, if you apply date condition in the above table,

date(CanonicalDate,'DD-MMM-YYY-HH-mm-ss') you will be able to see different time stamps in  the same date field.

to eliminate the time stamp you can use floor() function

[#9]

Hi Gysbert Wassenaar,

If possible once check with above.qvf file. In sheet i have used weekdays  to show the data.

My table contains only the data what it is showing in monday. but i don't know from where the other days data is getting.

Please check and help to solve on it.

Thanks,

Pramod

[rwunderlich]

As others have pointed out, you do have time fractions in some of your dates. You can see that by using

=timestamp(CanonicalDate)

in your filter pane.

Floor() all your CannonicalDate values, including the ones you load into the mapping table.

-Rob