2 Replies Latest reply: Mar 22, 2013 4:38 AM by Some Nath Roy RSS

    How to concatenate a QVD to other QVD based on the condition?

      Hi,

       

      I need to concatenate a QVD to other QVD based on the month end of "Month_date" column

       

      CurrentData:

      LOAD Id,

                Department,

                Month_date

      From Dummy.xlsx(ooxml, embedded labels);

       

      STORE CurrentData into CurrentData.qvd(qvd);

       

      If  MonthEnd(Month_date) then

       

      Concatenate CurrentData.qvd(qvd) to HistoricalData.qvd(qvd);

       

       

      But the above Script marked in Red is not working.

       

      Anyone could you help me on this...