Generate no based on Lot no.

[rohit214]

Hi All,

I want to generate the no against the lot no. since i have a common commision no. but in a commision no there are n no of lots so i want to generate no agaist lot no.

ex.

Commision no	Lot no.	reuired output
201282591201	10	1
201282591201	11	2
201282591201	12	3
201282591201	13	4
201282591201	14	5
201282591201	15	6
201282591201	16	7
201282591201	17	8

so every commision wise there are n no of lot no so i awnt those no based on lot no.

please find the attached sample data.

looking for help

Regards

Rohit

[rohit214]

any one please help...

[saumyashah90]

Use RowNo() while loading

[tresesco]

Try something  like this:

Load [Commission No],

          [Lot No],

          If( [Commission No]=Peek('[Commision No]', Peek('Count')+1, 1) as Count

From <> Order By [Commision No], [Lot No] ;

PFA

[#5]

Hi

use autonumber function to get it

load *,AutoNumber(LOT_No) as no1 Resident tablename ;

[sujeetsingh]

hi,

You can use Recno() as Newlot

Aotohash() function

and even you van have it it UI too

[rohit214]

Dear Arya,

We already did that but it is not working please use the attched file. to gegerate the no.

Regards

Rohit

[rohit214]

Dear Sujeet,

Recno will give at your record in which row no .

and we also tried what you have suggest but it is not giving the correct value.

Regards

Rohit.

[rohit214]

Dear Tresesco,

one more help i want is

if the lot no is same then the count no is also same for example.

i attched sample file please help me.

[rohit214]

Dear Tresesco ,

your previous solution is correct as per what logic i share with you.

but for second issue If you have any idea please share with me.

Regards

rohit