Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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

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

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

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

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