Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for
Did you mean:
Contributor III

## autonumber

 this is my original data Original Data Id Date A1 5/12/13 12:00 AM A1 5/13/13 12:00 AM A1 5/14/13 12:00 AM A1 5/15/13 12:00 AM B2 5/16/13 12:00 AM B2 5/17/13 12:00 AM C4 5/18/13 12:00 AM C4 5/19/13 12:00 AM C4 5/20/13 12:00 AM D5 5/21/13 12:00 AM E6 5/22/13 12:00 AM I want That  Result From Above Id Date Row No A1 5/12/13 12:00 AM 1 A1 5/13/13 12:00 AM 2 A1 5/14/13 12:00 AM 3 A1 5/15/13 12:00 AM 4 B2 5/16/13 12:00 AM 1 B2 5/17/13 12:00 AM 2 C4 5/18/13 12:00 AM 1 C4 5/19/13 12:00 AM 2 C4 5/20/13 12:00 AM 3 D5 5/21/13 12:00 AM 1 E6 5/22/13 12:00 AM 1
14 Replies
Not applicable

hi

try to use iterNo() function

see attached file

hope this helps you

Regards

Not applicable

Hi Zainab,

You can use the Recno() Function like below

id,

Date,

Rowno() As Rowno

From Table1;

Regards,

Santhosh G

Partner - Champion III

See this discussion Re: Re: Numbering Rows more examples? for an example QVW that solves your problem and two other numbering schemes you may have to deal with in the future.

Good luck,

Peter

MVP

AutoNumber(Date) as RowNo  ?

Not applicable

hi

According to your requirement. try this code or see attachment.

[Original Data]:

LOAD Id, date(Date#(Date,'M/DD/YY hh:mm TT'),'M/DD/YY hh:mm TT') as Date_new,

if(Previous(Id)<>(Id),1, RangeSum(1,Peek(RowNo))) as RowNo ;

LOAD * Inline [

Id,    Date

A1,    5/12/13 12:00 AM

A1,    5/13/13 12:00 AM

A1,    5/14/13 12:00 AM

A1,    5/15/13 12:00 AM

B2,    5/16/13 12:00 AM

B2,    5/17/13 12:00 AM

C4,    5/18/13 12:00 AM

C4,    5/19/13 12:00 AM

C4,    5/20/13 12:00 AM

D5,    5/21/13 12:00 AM

E6,    5/22/13 12:00 AM

then output like this--

 Id Date_new RowNo A1 5/12/13 12:00 AM 1 A1 5/13/13 12:00 AM 2 A1 5/14/13 12:00 AM 3 A1 5/15/13 12:00 AM 4 B2 5/16/13 12:00 AM 1 B2 5/17/13 12:00 AM 2 C4 5/18/13 12:00 AM 1 C4 5/19/13 12:00 AM 2 C4 5/20/13 12:00 AM 3 D5 5/21/13 12:00 AM 1 E6 5/22/13 12:00 AM 1
Contributor III
Author

the data i have not load in order

Partner - Specialist

Hi Zainab,

Try below syntex.

Ex:

AutoNumber(Date,Id) as RNo

Not applicable

Yu need to sort it if you want to do that

Do a second resident load and do an ORDER BY

Fabrice

Contributor III
Author

resident load , is difficult , table size is very big

Community Browser