topic Re: Need to add upper in QlikView

Need to add upper

Wed, 24 Aug 2016 16:02:20 GMT

Right(LastModifiedBy, Len(LastModifiedBy) - 3) as LastModifiedBy,

My data has both upper and lower case but the file I am linking it to is all upper case.

Where dos the UPPER clause go? Tried a few different ways but no luck.

agomes1971 — Wed, 24 Aug 2016 16:06:09 GMT

Hi,

Try like this,

Load Upper(LastModifiedBy) as LastModifiedBy;

select LastModifiedBy from your_table;

HTH

André Gomes

sunny_talwar — Wed, 24 Aug 2016 16:09:22 GMT

You can do this:

Upper(Right(LastModifiedBy, Len(LastModifiedBy) - 3)) as LastModifiedBy,

Wed, 24 Aug 2016 16:17:22 GMT

Not sure where to put it at

[Rxs]:
LIB CONNECT TO [pharmoresql production (pharmore_rwinkel)];

LOAD
FacID,

Right(LastModifiedBy, Len(LastModifiedBy) - 3) as LastModifiedBy,

PharmID;

SQL SELECT
FacID,

LastModifiedBy,
PharmID

FROM Rx.dbo.Rxs

agomes1971 — Wed, 24 Aug 2016 16:20:16 GMT

Instead of

Right(LastModifiedBy, Len(LastModifiedBy) - 3) as LastModifiedBy,

put

Upper(Right(LastModifiedBy, Len(LastModifiedBy) - 3)) as LastModifiedBy,

HTH

André Gomes