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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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;