AUTOGENERATE

[maniram23]

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 · Accepted solution]

Try like:

Load

        RowNo() as ID,

        SubField(name,'/') as Name

Inline [

id, name

1, a/b/c/d]

[vinieme12]

What should be the output for below??

id, name

1, a/b/c/d

2, x/y/z

[satheshreddy]

Hi Vineeth,

output will like below.

ID	name
1	a
2	b
3	c
4	d
5	x
6	y
7	z

Regards

Sathish