how to convert a one column input to multiple column

[ashokkumarss]

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..

[prasson_ibm]

When is the interview?

[ashokkumarss]

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 ..

[prasson_ibm]

Hi,

Please let us know what was your approach to get the output.

[ashokkumarss]

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 solution.. pls guide me in this situation..

i need guidance to solve this kind of inputs...

[ArndW]

This is a good place to use the loop functionality in a Transform stage.

In the Loop While condition put in "@ITERATION <= LEN(InColumn.InputString)"

Then in the Output just specify "InColumn.InputString[@ITERATION,1]" to put one character per row

[ray.wurlod]

What's the business case behind the requirement? That may assist in deciding the most appropriate algorithm - there are at least five different ways to solve this one.

[ashokkumarss]

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.

[oracle]

When is the interview?

Learn from Ray,andrw how they responded...don't discourage if some one genuinely wants to learn.