Position of field based on another one in script

Fri, 19 Jun 2015 19:46:28 GMT

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

Re: Position of field based on another one in script

maxgro — Fri, 19 Jun 2015 19:54:02 GMT

LOAD Store,

Contact,

[Wanted field],

AutoNumber(Contact, Store)

FROM

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

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

topic Re: Position of field based on another one in script in QlikView

Position of field based on another one in script

Re: Position of field based on another one in script