Rest Connector problem.

NZFei — Tue, 09 May 2017 00:21:50 GMT

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

Re: Rest Connector problem.

RSvebeck — Tue, 09 May 2017 05:08:17 GMT

Try this:

SQL SELECT
text("Code") as Code,
"__KEY_root"

i had the same issue when reading from a DB2 database and this trick solved it, but not sure it is possible with JSON/REST.

/Robert

topic Rest Connector problem. in QlikView

Rest Connector problem.

Re: Rest Connector problem.