Table mixed with upper and lower case

[dmxmikey]

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

[#2]

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()

[dmxmikey]

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

[dmxmikey]

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...

[#5]

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()

[dmxmikey]

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

thanks

Delivering the best in Foodservice...

[#7]

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;

[dmxmikey]

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

[#9]

Hi

can u post ur application