Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()
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
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...
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()
I’m getting the below error when I load my data
thanks
Delivering the best in Foodservice...
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;
do i need to edit anything on your script? as im still getting error
Hi
can u post ur application