Hello all,
I hope someone can help me with the following:
I have an issue with a Restconnector which random drops a lead zero!
In the preview of the data load selection is shows the “Id” correctly e.g. “000008” but the end result in Qlik sense is “00008”.
Load statement I use:
LIB CONNECT TO 'Ultimo_Article (mosa_cheus1)';
RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"Id",
"Description",
"__FK_items"
FROM "items" FK "__FK_items")
FROM JSON (wrap on) "root" PK "__KEY_root";
[items]:
LOAD [Id],
[Description]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_items]);
DROP TABLE RestConnectorMasterTable;
After Load the end result is the just one lead zero missing!
Has anybody experience with this issue?
Thanks for the Help!
Ceriel