topic Re: Table mixed with upper and lower case in QlikView

Table mixed with upper and lower case

dmxmikey — Thu, 30 Oct 2014 13:20:44 GMT

Have a table with mixed data in upper cases and lower case, and would like my script to ignore case sensitivity, my script looks like this at the moment, so how do I solve this.

All:

SQL SELECT

"alg-code",

"alg-stat",

"p-code",

"qual-code"

FROM PUB.Prodalg;

STORE All INTO \\TRS7\QLIKVIEWDATAFILES\QVDS\All.qvd;

Thank you

Re: Table mixed with upper and lower case

Thu, 30 Oct 2014 13:26:43 GMT

Hi,

Tablename:

Load upper("alg-code") as ALG-CODE ,

upper("alg-stat") as ALG-STAT,

upper( "p-code") as P-CODE,

upper("qual-code") as QUAL-CODE;

SQL SELECT

"alg-code",

"alg-stat",

"p-code",

"qual-code"

FROM PUB.Prodalg;

STORE Tablename INTO \\TRS7\QLIKVIEWDATAFILES\QVDS\All.qvd;

Here what ever you want you can use upper(), lower()

Re: Table mixed with upper and lower case

dmxmikey — Thu, 30 Oct 2014 13:41:47 GMT

attached is the data from my database and the qual-code field has a mixture of capitals and lower cases, so need to ignore case sensitivity.

Thanks

Re: Table mixed with upper and lower case

dmxmikey — Thu, 30 Oct 2014 13:43:33 GMT

attached is the data from my database and the qual-code field has a mixture of capitals and lower cases, so need to ignore case sensitivity.

Thanks

Delivering the best in Foodservice...

Re: Table mixed with upper and lower case

Thu, 30 Oct 2014 13:46:46 GMT

Tablename:

Load *,

upper("qual-code") as QUAL-CODE;

SQL SELECT

"alg-code",

"alg-stat",

"p-code",

"qual-code"

FROM PUB.Prodalg;

STORE Tablename INTO \\TRS7\QLIKVIEWDATAFILES\QVDS\All.qvd;

Here what ever you want you can use upper(), lower()

Re: Table mixed with upper and lower case

dmxmikey — Thu, 30 Oct 2014 15:12:59 GMT

I’m getting the below error when I load my data

thanks

Delivering the best in Foodservice...

Re: Table mixed with upper and lower case

Thu, 30 Oct 2014 15:20:11 GMT

Hi,

try this it will work

Tablename:

SQL SELECT

"alg-code",

"alg-stat",

"p-code",

"qual-code"

FROM PUB.Prodalg;

Tablename1:

Load *,

upper("qual-code") as QUAL-CODE

resident Tablename;

STORE Tablename1 INTO \\TRS7\QLIKVIEWDATAFILES\QVDS\All.qvd;

Re: Table mixed with upper and lower case

dmxmikey — Thu, 30 Oct 2014 15:28:52 GMT

do i need to edit anything on your script? as im still getting error

Re: Table mixed with upper and lower case

Thu, 30 Oct 2014 15:31:19 GMT

can u post ur application