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

    Data loss when concatenate

    Diego Sandoval

      Hello comunity,

      Please help with this problem.

      I have 2 qvd files I want to concatenate.

      QVD1 fileds:

      m.png

      QVD2 fields:

      p.png

      to concatenate I use:

      final:

      load * from qvd1.qvd (qvd);

      concatenate

      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);


      Notes:

      - QVD1 has almost 14M of rows.

      - QVD2 has 4100 rows of rows.