Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

 2 Answer(s)

  • @calculate.1152
    Recommendations Offline Message

    over 6 years ago

    Hello Buddy,

    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except that I have

    This can be acheived within mapping using variables in the expression transformation. below is the pseudo code logic

     

    HDR=SUBSTRING(COL1, 1, 4)

    TR=SUBSTRING(COL1, 1, 4)

    HDR_V=IIF(HDR='HEAD',COL1) ---if you multiple cols cancatenate it

    HDR_O=HDR_V

    D_CNT_Out_v=Detail_CNT_V

    D_CNT_V=IIF (HDR='HEAD', 0,D_CNT_V+1)

    D_CNT_Out=D_CNT_Out_v

    FIL_FLAG=IIF(TR='TRAIL', 1, 0)

     

    SRC-SQ-EXP-FIL-TGT

     

    In Filter use the condition FIL_FLAG=1  and connect HDR_out, D_CNT_OUT and TRAILER to filter

    and Target

    THANK YOU!! This saved my butt today, I’m immensely grateful.

    Kind Regards,

    Mark
Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: