12 Replies Latest reply: Dec 28, 2015 4:42 AM by Fateh FATEHCH RSS

    Load data from database using concatination

      Hi all;

      i work with database Sqlserver in our server  , i succeded to have connction between Qlikview and Data base,

      I selected the values that i want to load  like :

      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False; ..........;

       

      SQL SELECT

      code1,code2

      from ......

       

      i want to concatinate these two code  like :

      SET Verbatim = 1;

      LOAD Distinct Text(code1&code2) as Concat   

      FROM    database.table


      how do i do for loading this COncat please


      thanks all;