Position of field based on another one in script

[#1]

Hi,

thanks in advance for helping! I'm trying to achieve the following in my script...The last field on the right is what I would like. in the example, Jim is contact #1 for Store A, and Joe is #2 for the same store. As I load my contacts, how can I assign a position? Autonumber? RecNo? thanks!

Store	Contact	Wanted field
A	Jim	1
A	Joe	2
A	Jane	3
B	Jack	1
B	Juliet	2
C	Jared	1
C	June	2

[maxgro · Accepted solution]

LOAD Store,

     Contact,

     [Wanted field],

     AutoNumber(Contact, Store)

FROM

[https://community.qlik.com/thread/169219]

(html, codepage is 1252, embedded labels, table is @1);