Problem: incorrect loading of fields

Wed, 18 May 2011 20:17:22 GMT

Hi,

i have a problem with loaded fields that do not match what the original database have. For example:

The original database looks like this:

Usr_ID	Usr_Name
080010	John
80010	Tom

But when I do the load, it changes to this:

Usr_ID	Usr_Name
080010	John
080010	Tom

The Usr_ID 80010 doesn't exists anymore, and the Usr_ID 080010 its associated with both John and Tom, which is incorrect.

The code is this simple:

LOAD Usr_ID,

Usr_Name;

SQL SELECT Usr_ID,Usr_Name

FROM `dbo_Users`;

Thanks in advance.

PS. Sorry for my english, my native language is Spanish

Wed, 18 May 2011 20:32:10 GMT

My guess is use text(Usr_ID). Maybe QV thinks Usr_ID is a number (which it is) so it takes the leading 0 off which makes them equal to each other.

Thu, 19 May 2011 00:57:12 GMT

Thank you very much! Problem solved.

topic Problem: incorrect loading of fields in QlikView