topic Re: AUTOGENERATE in QlikView

AUTOGENERATE

maniram23 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

I have table like this,

id, name

1, a/b/c/d

But i want my output like this

id, name

1, a

2, b

3, c

4, d

Please help me.

Regards

tresB — Mon, 06 Feb 2017 05:53:27 GMT

Try like:

Load

RowNo() as ID,

SubField(name,'/') as Name

Inline [

id, name

1, a/b/c/d]

vinieme12 — Mon, 06 Feb 2017 06:02:40 GMT

What should be the output for below??

id, name

1, a/b/c/d

2, x/y/z

satheshreddy — Mon, 06 Feb 2017 06:27:32 GMT

Hi Vineeth,

output will like below.

Regards

Sathish