3 Replies Latest reply: Dec 8, 2017 5:18 AM by Adam Hájek RSS

    Data loading as ?

    Martyn Collis

      Hi All,

       

      I am working on a project whereby my data is being loaded as a "?" instead of the data that is present in the database.

      for example, my database has data like this:

      AddressIDpropertyname
      270Blah
      271blah 2
      273
      ......
      12548more blahs

      Whereas Qlik Sense is loading it as:

      AddressIDpropertyname
      ?Blah
      ?blah 2
      ?
      ......
      ?more blahs

       

      I cannot work out why the data is loading as it is, source data is coming from a SQL server (2012).

      I have verified that the data is correct in the database and is correct in the QVD

       

      This is happening on several tables especially where there is an ID field.

      Any ideas experts?