Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everybody,
how I can assign a value(Id) to a CalendarDate, like:
I have:
storeid | calendardate | Id
123 | 22.01.2012 | 2
123 | 23.01.2012 | 1
123 | 26.01.2012 | 5
123 | 01.02.2012 | 3
123 | 07.02.2012 | 4
I need:
storeid | calendardate | Id
123 | 22.01.2012 | 1
123 | 23.01.2012 | 2
123 | 26.01.2012 | 3
123 | 01.02.2012 | 4
123 | 07.02.2012 | 5
Thx in advance.
You can use RecNo() function to generate numbers from 1 onwards.
RecNo() function will doesn't work because I have group my Id to the StoreID:
My Table look like this::
storeid | calendardate | Id
123 | 22.01.2012 | 2
123 | 23.01.2012 | 1
123 | 26.01.2012 | 5
123 | 01.02.2012 | 3
123 | 07.02.2012 | 4
456 | 28.01.2012 | 2
456 | 30.01.2012 | 1
789 | 24.01.2012 | 2
789 | 28.02.2012 | 3
789 | 01.03.2012 | 1
I want for Id the same order as calendardate.
Convert the date in to the real date. sort by the date then and use recno() to generate your row.
mmmm load the calendardate 2 times like this
load
calendardate,
calendardate as ID,
....
and when use ID change the format number for Integer.
Maybe help you
the calendardate is already in the right order, I want the same order for Id.
autonumber(calendardate, storeid) as Id
-Rob
Hi,
Have you tried with the RowNo() function?
Celambarasan