Discussion Board for collaboration on QlikView Scripting.
I am trying to reduce the data based on the user logged in . Qvw file is not even prompting for the username and password.
Please find the below script.
Username Password Access CID
User1 user1 user c1
User2 user2 user c2
User3 user3 user c3
User4 user4 user c4
Admin Admin Admin *
Username, Password, Access, CID
I have enabled the Initial Data reduction based on the section Access.
I am not sure why it is not prompting for user name and password.
Go to Solution.
I was using like this
So it was prompting me only the Password in section Access. it was the username Caused the problem. It should be Userid.Once i changed to userid it is working fine.
Your fields have to be in uppercase and you have to rename them like this :
LOAD ACCESS, USERID, PASSWORD, ... FROM Table1;
In the ACCESS field, you have to enter these values : ADMIN or USER
Hope it helps you.
You need to observe instructions regarding use of capital letters and need to insert "STAR IS"-command.
SECTION ACCESS; STAR IS *; Table1: LOAD * INLINE [USERID, PASSWORD, ACCESS, CID User1, user1, USER, c1 User2, user2, USER, c2 User3, user3, USER, c3 User4, user4, USER, c4 Admin, Admin, ADMIN, *]; SECTION APPLICATION;Data: NOCONCATENATE LOAD * RESIDENT Table1;
Hi Peter and Martin,
Thanks for your response. Now the funniest thing is it is prompting only for the Password.
And i am not able to access the file itself.
Any way to resolve this...
Continue with the backup-copy ....
That is the disappointment because i dont have the backup.Want to know when it will prompt only the password.At what scenario
I found the reason why it is prompting only the Password and i have fixed the issue.Thanks for your support
can you tell me the scenario....
what is the reason it was prompted only password....