2 Replies Latest reply: Dec 17, 2013 1:38 PM by Gysbert Wassenaar RSS

    Load from sql server

    Massimo Grossi


      I'm loading some data from a sql server database

      CODE 001,         description (TXT) Acquisto su ....

      CODE 01,           description (TXT) Vendita normale  

      qv from sql server 1.jpg


      Same data loaded with same query in qlikview (image below)

      DLVREASON:

      LOAD   *   ;

      SQL

      select CODE, TXT

      from dlvreason where code < '20'

      and dataareaid='els6' order by 1;


      and I have the same 001 CODE with two different description

      Code 001, description (TXT) Acquisto su ....

      Code 001, description Vendita normale 


      has anyone encountered the same problem? solution?


      qv from sql server 2.jpg