Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
liam_hanninen
Creator
Creator

Data Load Editor Jumbles IDs on Load

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";

postgresOutput.pngQlikloadoutput.png

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

LOAD text(id) as activityID


-Rob

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

LOAD text(id) as activityID


-Rob

liam_hanninen
Creator
Creator
Author

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.QlikoutputText.png

liam_hanninen
Creator
Creator
Author

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";

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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