topic Problem with codes in MQ SQL Database - different codes become the same ... ?! in QlikView

Problem with codes in MQ SQL Database - different codes become the same ... ?!

ivan_will — Tue, 22 Nov 2011 12:52:12 GMT

Hi all,

I have problems with codes in MQ SQL database.

The problem is that in the DB there is Document Codes like: 01 ; 001 ; 0000000001

When I reload all the lines all of the above codes become like 0000000001 and there is dublication in my data!

When I use where func by customer number it shows 01 but when make with two client names the codes become 001 (fist dos is 01 and the second 001)

Ideas?????

Problem with codes in MQ SQL Database - different codes become the same ... ?!

Tue, 22 Nov 2011 13:11:14 GMT

Hello Ivan.

I had the same problem.

Try to force the format in string... like this:

[TABLE_ALIAS]:

Load Text(Document_Code) as Document_Code_Formated, *; //This load command will load data from the SQL command bellow, forcing the Document_Code to be in a string format

SQL Select * From SQL_Table;

That will do (perharps hahaha)

Regards,

Bruno