How to load distinct dates?

[#1]

Hi All,

My table is having one column only as Date

Date

3/13/2013

3/13/2013

3/13/2013

3/13/2013

3/14/2013

3/14/2013

I want to load only distict dates is another table like:

Date

3/13/2013

3/14/2013

How to do this?

Thanx in advance..

[#2]

LOAD DISTINCT

   Date

FROM Table;

[jagan]

Hi,

try

LOAD

     DISTINCT Date

FROM DataSource;

Regards,

Jagan.

[#4]

It is not working. Pl find attched application.

[#5 · Accepted solution]

Try with this. your dates have decimals (hours, minutes, etc, are difrerentes)

Audits:

LOAD 

     Date(DayStart(Timestamp)) as Calendar_Date

FROM Logs\Audit*.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

where Date(Timestamp)>='01/01/13';

Ricardo

[CELAMBARASAN]

Hi,

You can use like this way also

Audits:

LOAD

     Date(Floor(Timestamp)) as Calendar_Date

FROM Logs\Audit*.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

where Date(Timestamp)>='01/01/13';

Before doing this type of operation make sure that you don't need time(hours and minutes) for analysis.