Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Markbhai
Creator
Creator

How to convert column name to upper case

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.

 

Labels (3)
2 Replies
David_Friend
Support
Support

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

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

Markbhai
Creator
Creator
Author

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;