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

[saumyashah90]

Hey Rohit

please see the working example

Please mark answer as correct if you get the output

[rohit214]

Dear Sumaya,

one more help i want is

if the lot no is same then count no should also same.

i have attached sample file please help me out to sort that problem.

Regards

Rohit

[saumyashah90]

Dude but above answer was correct right?

[rohit214]

yes Sir, above answer is correct but now i am facing another problem please help me.

Regards

Rohit

[CELAMBARASAN]

Hi,

Try with AutoNumber function

LOAD Comm_No,

     LOT_No,

     AutoNumber(LOT_No, Comm_No) AS Output

FROM

dATA.xlsx

(ooxml, embedded labels, table is Sheet1);

Hope that helps

Celambarasan

[saumyashah90]

Dude i have a question for this
i.e you should not have repetitive data .

[rohit214]

Dear Sir,

Please use this file.

Regards

Rohit

[rohit214]

Dear Sir,

I am not able to get you.

Regards

Rohit

[saumyashah90]

Please check this for your use.

mark Correct if it is Correct

[CELAMBARASAN · Accepted solution]

PFA