Different way of using subfield..

[#1]

Hi Community,

I have set of records. Using Subfield function i have split and it is in the below format

Ename	Fname	lastname
Yogesh Kumar	Yogesh	Kumar

LOAD

Subfield(ENAME,' ', 1) as FirstName,

  Subfield(ENAME,' ',2) as SecondName,

resident Concat;

now i need that in different format i.e., instead of splitting in side ways it should go in row wise..Check below for clear understanding.

Expected

Ename	Name
Yogesh Kumar	Yogesh
Yogesh Kumar	Kumar

Please help me.

regards,

yogesh

[lironbaram]

LOAD

ENAME,

Subfield(ENAME,' ') as Name

resident Concat;

[#3]

Thank You Liron,

Cheers