topic Re: what's wrong with this script in QlikView https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821340#M289510 <HTML><HEAD></HEAD><BODY><P>One error is here:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">LOAD <STRONG>'ADMIN'</STRONG> AS ACCESS</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">you do not need the single quote<BR /></SPAN></P></BODY></HTML> Mon, 30 Mar 2015 14:37:59 GMT robert_mika 2015-03-30T14:37:59Z what's wrong with this script https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821339#M289509 <HTML><HEAD></HEAD><BODY><P>Section Access;</P><P></P><P></P><P></P><P></P><P>LOAD&nbsp; Distinct</P><P>&nbsp;&nbsp;&nbsp;&nbsp; USER_LOGIN</P><P>&nbsp;&nbsp;&nbsp; </P><P>FROM</P><P>QVDS\SILK_USER_PROJECT_DW.qvd</P><P>(qvd);</P><P></P><P></P><P>SECURITY:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; ACCESS, USERID, PASSWORD, NTNAME</P><P>&nbsp;&nbsp;&nbsp; ADMIN, ALI, HIJAZI, *</P><P>];</P><P></P><P></P><P></P><P></P><P>Concatenate(SECURITY)</P><P>LOAD 'ADMIN' AS ACCESS,'*' AS USERID, '*' AS PASSWORD,'lb\' &amp; USER_LOGIN AS NTNAME</P><P>Resident TEMP_SECURITY;</P><P>DROP Table TEMP_SECURITY;</P><P></P><P></P><P>Section Application;</P><P></P><P>I'm getting an error that says general script error</P><P></P><P>please advise</P></BODY></HTML> Mon, 30 Mar 2015 14:35:03 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821339#M289509 ali_hijazi 2015-03-30T14:35:03Z Re: what's wrong with this script https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821340#M289510 <HTML><HEAD></HEAD><BODY><P>One error is here:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">LOAD <STRONG>'ADMIN'</STRONG> AS ACCESS</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">you do not need the single quote<BR /></SPAN></P></BODY></HTML> Mon, 30 Mar 2015 14:37:59 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821340#M289510 robert_mika 2015-03-30T14:37:59Z Re: what's wrong with this script https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821341#M289511 <HTML><HEAD></HEAD><BODY><P>Can you show the error?</P></BODY></HTML> Mon, 30 Mar 2015 14:55:33 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821341#M289511 2015-03-30T14:55:33Z Re: what's wrong with this script https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821342#M289512 <HTML><HEAD></HEAD><BODY><P>I think QlikView simply cannot find the TEMP_SECURITY table because apparently you forgot to give the top table a name...</P><P></P><P>After <SPAN style="font-family: 'courier new', courier;">Section Access;</SPAN> add this line:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">TEMP_SECURITY:</SPAN></P></BODY></HTML> Mon, 30 Mar 2015 14:55:34 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821342#M289512 Peter_Cammaert 2015-03-30T14:55:34Z Re: what's wrong with this script https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821343#M289513 <HTML><HEAD></HEAD><BODY><P>NO i have to put this </P><P>it doesn't work either without single quotes</P></BODY></HTML> Mon, 30 Mar 2015 15:01:26 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821343#M289513 ali_hijazi 2015-03-30T15:01:26Z Re: what's wrong with this script https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821344#M289514 <HTML><HEAD></HEAD><BODY><P>are u having/defined this table "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TEMP_SECURITY</SPAN>"?</P></BODY></HTML> Mon, 30 Mar 2015 15:03:05 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-script/m-p/821344#M289514 buzzy996 2015-03-30T15:03:05Z