6 Replies Latest reply: Aug 13, 2012 9:19 AM by Roberto Postma RSS

    QV merges "text" that is not similar

    Kristian König

      Hello again,

       

      i have a problem and i just cant see why it is so:

       

      ReItem:

      SQL SELECT "DIMENSION10_",

          "DIMENSION3_",

          "DIMENSION4_",

          ITEMID,

          ITEMNAME

      FROM dbo.INVENTTABLE;

       

      Item:

      NoConcatenate LOAD

             "DIMENSION10_",

          "DIMENSION3_",

          "DIMENSION4_",

          ITEMID,

          ITEMNAME

      Resident ReItem;

       

      DROP table ReItem;

       

      Store Item into '\\domainsvr\Baze\Item.qvd';

       

      This is my script and it should give me the searched Data.

       

      My Problem(i just checked on this one):

      I have 2 "similar" ITEMID numbers: 416 8 and 041 68 but after i run this script it only shows me 041 68(as ItemID) but 2 different ITEMNAME!! It should be 2 ItemIDs and 2 ItemaNames,,,

       

      Does anybody has an idea why the scrpit merges these two text numbers? Or how i could fix this issue?I dont see why...

       

      Thank you for your help and i hope for some...

       

      Greetings,

       

      Kristian