Data transformation during load

[#1]

Hello,

Sometimes in my data tables into DB we have such values in the same collumn like "model1", "MODEL1"

Is it possible to have some rule(the first letter should be capital and other should be lower case) defined in QlickView which will give me all data in particular collumn as "Model1" so the all data in this collumn.

If this is possible what impact such transformation can have on performance?

Thanks

[#2]

You could use the capitalize() function (one of QlikView's string functions) to transform columns to proper case.  You could do this either when you load in script, or as an expression in your charts, etc.

[#3]

Hello Donald,

Thanks for hint

I received this during re-load

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'Capitalize' is not a recognized built-in function name.

Thanks

[#4 · Accepted solution]

Capitalize is a QlikView function that you can use in your QlikView LOAD statements and script, but sounds like you are using it in your SQL SELECT statement, thus the error.

SQL Server doesn't have a built-in fuction for Title or Proper case, but you could write one easily enough (or just Google for functions already written and tweak as needed).  But you could instead add a LOAD statement to your SQL SELECT and use QlikView's Capitalize().

LOAD

     Field1,

     Field2,

     Capitalize(Field3) As Field3;

SQL SELECT

     Field1,

     Field2,

     Field3

FROM xxx.dbo.tblData;

[#5]

Thank a lot Donald!