topic Create an ID_COUNTER within a field in QlikView

Create an ID_COUNTER within a field

andrew001 — Sun, 04 Nov 2012 10:49:42 GMT

Hi

From this table

tab1:
load *

inline
[CTP, EMAIL, ADDRESS
012,a012_1@d.com,via_xyx
012,a012_2@d.com,via_xyx
012,a012_3@d.com,via_xyx
014,a014_1@d.com,via_xyx
014,a014_2@d.com,via_xyx
016,a016_1@d.com,via_xyx
018,a018_1@d.com,via_xyx
018,a018_2@d.com,via_xyx]

I'd like to obtain a table like (by script) this: with a ID_COUNTER within CTP field:

ID_COUNTER CTP EMAIL ADDRESS

1 012 a012_1@d.com via_xyx

2 012 a012_2@d.com via_xyx

3 012 a012_3@d.com via_xyx

1 014 a014_1@d.com via_xyx

2 014 a014_2@d.com via_xyx

1 016 a016_1@d.com via_xyx

1 018 a018_1@d.com,via_xyx

2 018 a018_2@d.com via_xyx]

Thanks

Re: Create an ID_COUNTER within a field

somenathroy — Sun, 04 Nov 2012 11:43:24 GMT

tab1:

load *

inline

[CTP, EMAIL, ADDRESS

012,a012_1@d.com,via_xyx

012,a012_2@d.com,via_xyx

012,a012_3@d.com,via_xyx

014,a014_1@d.com,via_xyx

014,a014_2@d.com,via_xyx

016,a016_1@d.com,via_xyx

018,a018_1@d.com,via_xyx

018,a018_2@d.com,via_xyx];

tab2:

NoConcatenate

LOAD *,

if(CTP = Previous(CTP), Peek('ID_COUNTER') + 1, 1) as ID_COUNTER

Resident tab1;

DROP Table tab1;

Regards,

Som