Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

Variables in Section Access

Hi All. I want to use variable in section access
I set variables in Hidden Script. And then bring them into section access part. For some reason this solution doesn't works. I can't login with User admin123.  Please help to understand how to use variables foe Section Access.


 

Set Access = 'ADMIN';
Set UserID = 'admin123';
Set Password = '12345';


Section Access;
Star is *;
Access:
Load * Inline [
ACCESS, USERID, PASSWORD
ADMIN, demo, demo123
];

Concatenate (Access)
Load
'$(Access)' as ACCESS,
'$(UserID)' as USERID,
'$(Password)' as PASSWORD
AutoGenerate(1);

Concatenate (Access)
Load
ACCESS,
USERID,
PASSWORD
Resident
Access_List;

Section Application;

 

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi

All values must be in UPPER Case,  can you change and try once.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi

All values must be in UPPER Case,  can you change and try once.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Peony
Creator III
Creator III
Author

Thank you @MayilVahanan  
Your advice helped!