8 Replies Latest reply: Nov 19, 2014 2:33 AM by anbu cheliyan RSS

    Looping with Concatenation

      Hi All,

       

      How the looping is done with concatenation.

       

      As of now I am loading data as

       

      Actual:

       

      Load

      Month1,

      Year1,

      KeyData

      Resident Temp;

       

      Conatenate

      Load

      Month2,

      Year2,

      KeyData

      Resident Temp;

       

      Conatenate

      Load

      Month3,

      Year3,

      KeyData

      Resident Temp;

       

      Conatenate

      Load

      Month4,

      Year4,

      KeyData

      Resident Temp;

       

      Can we write a Loop statement so that it loops for 4 times with concatenating the data so that my code size decreases?