Condtional SeqNo creation while loading from Excel in qlikview

[#1]

Dear All, i am loading a DATA Like below

SrNo	Product
1	A
2	B
3	A
4	A
5	B
6	C
7	C
8	A

i required to add a extra column product SeqNo and result after load should be like below.. productwise seq No

SrNo	Product	ProductSeqNo
1	A	1
2	B	1
3	A	2
4	A	3
5	B	2
6	C	1
7	C	1
8	A	4

Please help.. want to do while loading script

[MarcoWedel · Accepted solution]

LOAD SrNo,

          Product,

          Autonumber(SrNo, Product) as ProductSeqNo

From YourExcelFile.xls(x);

the result should be

SrNo	Product	ProductSeqNo
1	A	1
2	B	1
3	A	2
4	A	3
5	B	2
6	C	1
7	C	2
8	A	4

regards

Marco

[senpradip007]

PFA.

[#4]

Thanks

[MarcoWedel]

you're welcome

regards

Marco