Leo

• Nov 11th, 2014

 

Hi Srav,

Use loop variable in Transformer
write condition @iteration<=6
Now write a looopvariable lpvar1 like
if @iteration=1 then left(input,1)
else
if @iteration=2 then Right(left(input,2),1)
like that till @iteration =6

Map this to the output column.

I think this will work.
If it works donate to save my city hit by hudhud cyclone

praveen

• Nov 25th, 2014

 

use pivot stage

Yash

• Jan 7th, 2015

 

Its pretty much easy using loop.

With below loop conditions in transformer.You can easily achieve it

Loop Condition: @ITERATION <= Len(DSLink2.COLB) --Loop will end when the length of the string hits.

Derivation: Right(Left(DSLink2.COLB, @ITERATION),1) --Right & Left functions will extract characters