autogenerate

[#1]

Hi All,

Can you pse assist. I have a date column with each date being received several times. I would like to create a distinct list of these dates, which I can do, but more importantly generate a number for each unique date (in sequence from 1-1 being the oldest date etc). Assuming the field name is Date, can anyone assist.

Thanks

Herbert

[Anonymous]

Try this,

dt:

Load

Distinct

dt

;

LOAD * INLINE [

    dt

    1/1/2015

    1/1/2015

    2/1/2015

    2/1/2015

    2/1/2015

    3/1/2015

    3/1/2015

    3/1/2015

    3/1/2015

];

dt2:

NoConcatenate

Load

dt,

rowno() as seqno

Resident dt

order by

dt desc

;

drop table dt;

[ramoncova06]

what you want is a master calendar, read this post The Master Calendar

[#4]

Hi There,

No, I am not looking for a master calendar.

I have a list of dates, which I need them loaded as they are, and I want to assign an autogenerate number to each of these dates as these dates represent sale days

Thanls