3 Replies Latest reply: Jan 19, 2015 2:48 PM by Jose Tos RSS

    Load Issue - Like Numbers Combining Records

      I have a model where I am loading information from a table.

       

      The customer_number field is a nchar(10) and the customer_name field is a nchar(36)

       

      I have 2 customers in the table

      Customer NumberCustomer Name
      0090060    USGS - National Wildlife Health Cent
      090060   Village of Wellington             

       

      I am loading only these 2 columns in this table to try and see what the issue is.

       

      So my load looks like the following

      Dim_Customers:
      LOAD

      "Customer number" as [Dim_Customers_CustomerNumber],
      "Customer name";
          
      SQL SELECT //"Dim_Customers_dKey",
      LTRIM(RTRIM(CAST("Customer number" as Varchar(10)))) as "Customer number",
      "Customer name"
      FROM [Dim_Customers];

       

      When I run the load I am getting one customer number of 090060 for both customer names.  Why?  Help?

       

      I am currently running QlikView 11.20.12235.0 SR5 64-bit.

       

      Thank you for your help in advance.

       

      Sincerely,

      CRusso