topic SUBFIELD() WITH row number in QlikView

SUBFIELD() WITH row number

ambasadorknz — Wed, 25 Jan 2017 11:19:01 GMT

Hi,

I have small problem with subfiled() function

i have:

when i use

load

id,

subfield(text,',') as field_1

i get only part of my finally solution:(

i need row number per iteration

like below:

Have you any idea how do row number per iteration??

sunny_talwar — Wed, 25 Jan 2017 12:36:46 GMT

Try this:

Table:

LOAD id,

SubField(text, ',') as text,

AutoNumber(RowNo(), id) as ITER_NO;

LOAD * INLINE [

id, text

1, "asd,fgh"

2, "qwe,rty,uio"

3, zxc

];

ambasadorknz — Wed, 25 Jan 2017 13:45:21 GMT

Thanks Sunny_T .

Worked perfectly.