topic Problem with data type while loading from SQL Server in QlikView

Problem with data type while loading from SQL Server

Mon, 03 Aug 2009 23:45:17 GMT

Hi! I am trying to load data into a QLikView document but I am facing some problems since it seems that during load, data type are "discarded". Example: I have a "Contract Number" that is a varchar, but when I try to load contract # = "1" and contract #="01", for the document both #'s are the same: "1".

Any ideas will be welcome.

Regards,

Gilberto.

Problem with data type while loading from SQL Server

rwunderlich — Tue, 04 Aug 2009 01:19:52 GMT

Use the text function -- text([Contract Number]) as [Contract Number]) -- to preserve the leading 0.

-Rob

Problem with data type while loading from SQL Server

Tue, 04 Aug 2009 01:33:43 GMT

Rob,

Thanks for the advice, but the problem is during data load and in the load script "text" is not recognized as a valid function name.

Regards,

Gilberto.

Problem with data type while loading from SQL Server

Anonymous — Tue, 04 Aug 2009 03:46:20 GMT

Are you using a preceding load?

Load text([Contract Number]) as [Contract Number];

SQL SELECT *

FROM SQLDATA_TABLE;

Problem with data type while loading from SQL Server

Fri, 28 Aug 2009 23:44:42 GMT

Thank you! This worked. Just a comment: since I have to include many fields more than the "Contract Number", the syntax for the Load and the Select should be:

Load text([Contract Number]) as [Contract Number], Other_Field1, Other Field3;

SQL SELECT *

From SQLDATA_TABLE;

Problem with data type while loading from SQL Server

hector — Fri, 28 Aug 2009 23:56:01 GMT

yes, that is the sintax, but '*' works too, but be carfeful, because if you do this, maybe QV gives you an error Duplicate Names are not allowed, because you used an alias with the same name of the original field

This should be work fine

Load

text([Contract Number]) as [Contract Number Text]

;

SQL SELECT *

From SQLDATA_TABLE;

bye