transformation logic

[prasson_ibm]

my input values are in this hierarchy format:-
depth,name
1,a1
2,b1
3,c1
1,a2

and i want output in this format:-
1 2 3
a1
a1 b1
a1 b1 c1
a2

i m using this logic:-

d=stageveriable for o/p col1
if depth=1 then input.name else d

f=stageveriable for o/p col2
if depth=2 then input.name else f

r= stageveriable for o/p col3
if depth=3 then input.name else r

with this logic last row is coming like this:-
a2 b1 c1
but it should come
a2


pls help me as soon as possible

[sanjay]

Hi
once you derive

1 2 3
a1
a1 b1
a1 b1 c1
a2

again check for col 1 in stage variable if there is change in row make col 2 and col 3 has bank
Thanks

my input values are in this hierarchy format:-
depth,name
1,a1
2,b1
3,c1
1,a2

and i want output in this format:-
1 2 3
a1
a1 b1
a1 b1 c1
a2

i m using this logic:-

d=stageveriable for o/p col1
if depth=1 then input.name else d

f=stageveriable for o/p col2
if depth=2 then input.name else f

r= stageveriable for o/p col3
if depth=3 then input.name else r

with this logic last row is coming like this:-
a2 b1 c1
but it should come
a2


pls help me as soon as possible

[kumar_s]

Will the output number of fields will be always constant? As giving in this example, 3?
And please avoid ASAP marks.