Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Lower case becomes upper case?

Hi, I am new to QV and I have a problem when writing script in the script editor. When I for example write Date, it turns out as DATE and hence gives me problems when I want to use it as key. I have tried to use the Edit functions to change it but have not managed, my best guess is that there is a setting somewhere that needs to be changed. Someone who knows?

Thank you in advance

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: Lower case becomes upper case?

This means that your ODBC driver always returns upper case. If you want lower case you will need to use a preceding load (See http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load)

HIC

6 Replies
Employee
Employee

Re: Lower case becomes upper case?

There is nothing in QlikVIew that would do this. But I have seen ODBC drivers that returns field names in UPPER case no matter what you write in the script...

Is it in a SELECT statement or in Load statement?

HIC

Not applicable

Re: Lower case becomes upper case?

It is in a select statement

//Emelie

Från: Henric Cronström

Skickat: den 19 mars 2013 23:10

Till: Emelie Nilsson

Ämne: - Re: Lower case becomes upper case?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Lower case becomes upper case?

created by Henric Cronström<http://community.qlik.com/people/hic> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/324007#324007>

anantmaxx
Contributor III

Re: Lower case becomes upper case?

it do not happens automaticall unless you rename a field

date as DATE?

are not you using UPPER Function?

Regards,

anant

sushil353
Honored Contributor II

Re: Lower case becomes upper case?

Please post your sample application

Not applicable

Re: Lower case becomes upper case?

Hi

My select statement looks like this

ODBC CONNECT TO MOVEX_MVXCDTAAPRD (XUserId is bXKNaVFMWDbSGRB, XPassword is bXcIUURNWLYWGED);

SQL SELECT EZACQT,

EZACTY,

EZAIT1,

EZAIT2 as Division,

EZAIT3 as Avdelning,

EZAIT4,

EZAIT5 as Orsakskod,

EZAIT6,

EZAIT7 as Ordernummer,

EZANBR,

EZCHID,

EZCHNO,

EZCONO,

EZDIVI,

EZERCD,

EZEVEN,

EZFACI,

EZFSRC,

EZITNO as Artikelnummer,

EZLMDT,

EZLMTS,

EZRGDT,

EZRGTM,

EZSENO,

EZTFAM,

EZTRDT as Date,

EZVONO,

EZVSER,

EZYEA4,

EZACAM as Belopp

FROM KAVLI.M3EDBPRD.CINACC

WHERE EZYEA4=2013 AND EZAIT1='4061' AND EZDIVI='020' AND EZEVEN='MM020'

But in the Table viewer it becomes upper case and to key with MITMAS I had to change Artikelnummer in MITMAS to upper case

Från: sushil kumar

Skickat: den 20 mars 2013 12:46

Till: Emelie Nilsson

Ämne: - Re: Lower case becomes upper case?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Lower case becomes upper case?

created by sushil kumar<http://community.qlik.com/people/sushil353> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/324265#324265>

Employee
Employee

Re: Lower case becomes upper case?

This means that your ODBC driver always returns upper case. If you want lower case you will need to use a preceding load (See http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load)

HIC

Community Browser