Tuesday, 14 August 2012

scenario 2



Input -
id     code
111   01,02,03
222   04,05
Expected output  -
id   code
111 01
111 02
111 03
222 04
222 05
Posted by at

2 comments:

  1. Anonymous4 March 2014 at 00:47

    Stg Var
    Count(code,',')+1 = StageVariable

    Loop Var
    @ITERATION <= StageVariable
    Field(code,',',@ITERATION)=LoopVariable

    O/P
    id=id
    LoopVariable=code

    ReplyDelete
    Replies
    1. Anonymous23 April 2014 at 04:07

      But in transformer there in no loop variable..................can u explain lit bit more

      Delete

Subscribe to: Post Comments (Atom)