topic Re: How to convert column name to upper case in Integration, Extension & APIs

How to convert column name to upper case

Markbhai — Tue, 19 Mar 2024 16:13:16 GMT

Hi Guys,

Section Access;
LOAD
* INLINE [
ACCESS, USER.EMAIL, SPDI
ADMIN, MARK.ROEBUCK@PROVEPRIVACY.COM, *
USER, ASWATH.P@emvigotech.com, ONE
USER, SATHEESH.M@EMVIGOTECH.COM, *
];
Section Application;

The above section access script in Qlik Sense sheet is working fine, but I want to restrict data based on the 'id' column instead of 'SPDI'. However, my column name is in lowercase. How can I convert it to uppercase in the section access.

Re: How to convert column name to upper case

David_Friend — Tue, 19 Mar 2024 17:27:01 GMT

@Markbhai use the upper() function, it works like this:

LOAD
upper(user.email) as USER.EMAIL,

Re: How to convert column name to upper case

Markbhai — Wed, 20 Mar 2024 02:57:32 GMT

Hi @Markbhai ,

I Load 'id' column but i got 'Field not found' error I attached my data model and error screenshot please share your feedback.

My Current Section Access Script,

Load
Upper(ACCESS) as ACCESS,
Upper(USER.EMAIL) AS USER.EMAIL,
Upper(id) as ID
INLINE [
ACCESS, USER.EMAIL, ID
ADMIN, MARK.ROEBUCK@*********.COM, *
USER, ASWATH.P@*******.COM, 36
USER, SATHEESH.M@*********.COM, *
];
Section Application;