SUBFIELD() WITH row number

[ambasadorknz]

Hi,

I have small problem with subfiled() function

i have:

id	text
1	asd,fgh
2	qwe,rty,uio
3	zxc

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:

id	field_1	ITER_NO
1	asd	1
1	fgh	2
2	qwe	1
2	rty	2
2	uio	3
3	zxc	1

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

[sunny_talwar · Accepted solution]

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]

Thanks Sunny_T .

Worked perfectly.