2 Replies Latest reply: Feb 21, 2012 5:56 AM by Przemek K RSS

    Join problems QVD with excel file

      Dear QV users,

       

      I have a QVD table and an excel file that I would like to join with the qvd table. I am using the JOIN function. The QVD table has an unique Jobnumber for each row. The Excel table has multiple rows with the same Jobnumber. Below I tried to make an example what goes wrong when I join the tables

       

      QVD:

      Jobnumber/Amount/Salesvalue

      10W3000/3000/10000

       

      Excel table:

      Join (QVD) load:

      Jobnumber/Amount

      10W3000/1500

      10W3000/1750

       

      Result should be:

      Jobnumber/Amount/Salesvalue

      10W3000/3000/10000

      10W3000/1500/0

      10W3000/1750/0

       

      But instead I get the following result:

      10W3000/3000/10000

      10W3000/1500/10000

      10W3000/1750/10000

       

      The result of this is that my Salesvalue for this order is 30000 instead of 10000.

       

      Regards,

       

      Aissam