8 Replies Latest reply: Apr 26, 2016 1:00 PM by Diego Sandoval RSS

    Data loss when concatenate

      Hello comunity,

      Please help with this problem.

      I have 2 qvd files I want to concatenate.

      QVD1 fileds:


      QVD2 fields:


      to concatenate I use:


      load * from qvd1.qvd (qvd);


      load * from qvd2.qvd (qvd);

      store final ...

      drop final;

      The problem is: when I read the final file the year and month flaged as 'P' are null.

      I have a QV Dashboard which calls serveral QVDs, and I use qualify and unqualify.

      qualify *;

      unqualify year, month, productCode, clientCode;

      load * from final.qvd (qvd);

      load * from final2.qvd (qvd);

      load * from final3.qvd (qvd);


      load * from final10.qvd (qvd);


      - QVD1 has almost 14M of rows.

      - QVD2 has 4100 rows of rows.