Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
PFA.
Thanks
you're welcome
regards
Marco