topic Re: Data Load Editor Jumbles IDs on Load in App Development

Data Load Editor Jumbles IDs on Load

liam_hanninen — Wed, 20 Jun 2018 21:02:42 GMT

I've never experienced this before and could not find any discussions on this. It's one of those problems that has be rubbing my eyes making sure I'm seeing straight. When I load a 6-row, 2-column table Qlik Sense desktop seems to lose and/or remap information. It looks like it remaps 'Meeting' and 'Support' to the wrong id.

Activity:

LOAD id as activityID,

activity as activityDesc;

SELECT "id",

"activity"

FROM "public"."hourtracker$activities";

Re: Data Load Editor Jumbles IDs on Load

rwunderlich — Wed, 20 Jun 2018 22:03:45 GMT

As a test, try using text() on the id to see if it changes anything.

LOAD text(id) as activityID

-Rob

Re: Data Load Editor Jumbles IDs on Load

liam_hanninen — Thu, 21 Jun 2018 14:42:16 GMT

Good thought perhaps this will tell us a little about how Qlik is reading it... This was using text(). I also tried num() and it showed the same thing. I exported to excel and it was just this string as well.

Re: Data Load Editor Jumbles IDs on Load

liam_hanninen — Thu, 21 Jun 2018 15:35:39 GMT

This led to fixing it when I put it in the SQL statement. I wonder if Qlik has an issue with big int from Postgres...

Activity:

LOAD id as activityID,

activity as activityDesc;

SELECT text(id) as id,

"activity"

FROM "public"."hourtracker$activities";

Re: Data Load Editor Jumbles IDs on Load

rwunderlich — Thu, 21 Jun 2018 16:50:42 GMT

Qlik tends to have issues -- truncation, loss or precision -- when a number exceeds 14 digits. In your case you can probably cast the value to integer (not sure of exact syntax for Postgres).

-Rob

http://masterssummit.com

http://qlikviewcookbook.com