Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ....
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 ....
Try:
LOAD Distinct
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))
Hi,
I checked i don't have timestamps for date fields.
Thanks,
Pramod
Hi See the date stamp in your date field
Hi,
You can see the attached image.
Thanks,
Pramod
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
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
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