DSXchange

got the idea how to do it.

get the input in stage variable
len(inputcol) = stagevariabl

looping

@iteration = stagevariable

right(left(inputcol,@iteration),1) - loopvar

loopvar - O/P

with guidance through my friend.

its its multiple columns to multiple rows, instead of pivot stage i will use transformers and use loop variable and do that.. or else, if the input was like s,s,a,k.. then i use str function and its possible to split but here, im little bit confused or in the tension i may unable to find out the sol...

already attended.. and myself also need to get clarification on this.. how to do it transformers.. if other languages like c, cpp worked.. but not in ds.. pls dont tease me, if possible clarify ..

hi i have situation like below.
I/P
NAME
ssak

O/P

NAME
s
s
a
k

how do i do this.. pls guide me..