Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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