1 Reply Latest reply: May 9, 2017 1:08 AM by Robert Svebeck RSS

    Rest Connector problem.

    Fei Xu

      Hi,

      I am using QlikView 12 SR5 (and have tested in Sense 3.1 server) with latest Rest connector and having this problem.

      On the data website, 3 and 03 are two staff codes. However when I load the data into QlikView, it shows either 3 or 03, making QlikView not know who is 3 and who is 03.

       

      When using wrap on:

       

      RestConnectorMasterTable:
      SQL SELECT
      "Code",
      "__KEY_root"

       

      FROM JSON (wrap on) "root" PK "__KEY_root";

       

       

      I have the result:

       

      When using wrap off:

      RestConnectorMasterTable:
      SQL SELECT
      "Code",
      "__KEY_root"
      FROM JSON (wrap off)
      "root" PK "__KEY_root";

       

      I have the result:

       

       

      When not using wrap:

      RestConnectorMasterTable:
      SQL SELECT
      "Code",
      "__KEY_root"
      FROM JSON
      "root" PK "__KEY_root";

       

      I have the result:

       

      These three results are different but all of them have the same problem. From the Rest connector internal key field "_KEY_root", we can see that Rest connector has realized that there are two staffs that are linked to 3 (they should be 3 and 03) but in the result data, they are both 3 or both 03. How can I load the data so that one staff has code 3 and the other has 03?

       

      Thank you very much!

       

      Fei