topic command line and /v switch in QlikView https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156181#M32142 <HTML><HEAD></HEAD><BODY><P>Shouldnt you be using SET rather than LET (LET tries to evaluate the expression)?</P><P>Why can you not use the contents of the variable XML_TABLE directly anyway?</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Tue, 23 Feb 2010 15:12:43 GMT 2010-02-23T15:12:43Z command line and /v switch https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156180#M32141 <HTML><HEAD></HEAD><BODY><P></P><P>I have a mess of xml files all with different names but same structure i need to load into Qlikview. I have a nice vbscript that searches a directory for xml files and passes the name of each file into Qlikview via the /v command line switch. Below is an example of a command line i'm trying to use.</P><P>"C:\Program Files\Qlikview 9.0\QV.EXE" /r /vXML_Table=L-0-1264676681640-5326.xml "C:\My Documents\Qlikview\LEAN.qvw"</P><P>Unfortunatly, it is not working. Qlikview opens and runs like usual, but variable XML_Table is not getting any value. The below LET statement is where I'm trying to pick up the variable the command line is passing:</P><P><B>LET</B> vXML = <B><I>$(XML_Table)</I></B>;</P><P>But as you can see from the log file excerpt below, vXML is not getting passed anything.</P><P>02/23/10 07:27:39: Execution started.<BR />02/23/10 07:27:39: QlikView Version:9.00.7436.8<BR />02/23/10 07:27:39: 0002 LET vLean = 'C:\My Documents\Lean\QVD'<BR />02/23/10 07:27:39: 0004 LET vLeanXML = 'C:\My Documents\Lean\L-0-1264676681640-5326.xml'<BR /><EM><STRONG>02/23/10 07:27:39: 0006 LET vXML =</STRONG><BR /></EM> 02/23/10 07:27:39: 0008 ShippingStatusRecord:<BR />02/23/10 07:27:39: 0009 LOAD<BR />02/23/10 07:27:39: 0010 ShippingStatusID,</P><P></P><P>Any one have any ideas where I'm going wrong?</P></BODY></HTML> Tue, 23 Feb 2010 14:09:05 GMT https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156180#M32141 gardan 2010-02-23T14:09:05Z command line and /v switch https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156181#M32142 <HTML><HEAD></HEAD><BODY><P>Shouldnt you be using SET rather than LET (LET tries to evaluate the expression)?</P><P>Why can you not use the contents of the variable XML_TABLE directly anyway?</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Tue, 23 Feb 2010 15:12:43 GMT https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156181#M32142 2010-02-23T15:12:43Z command line and /v switch https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156182#M32143 <HTML><HEAD></HEAD><BODY><P>Forgot to mention...</P><P>If you want to process a folder contents for a certain type of file extension(s) within the script you can do so using a 'FOR EACH...NEXT' loop - have a look at the help.</P><P>Regards,</P><P>Gordon</P></BODY></HTML> Tue, 23 Feb 2010 15:19:08 GMT https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156182#M32143 2010-02-23T15:19:08Z command line and /v switch https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156183#M32144 <HTML><HEAD></HEAD><BODY><P>Try *.xml in the FROM line.</P><P>Chris</P></BODY></HTML> Tue, 23 Feb 2010 15:36:27 GMT https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156183#M32144 2010-02-23T15:36:27Z command line and /v switch https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156184#M32145 <HTML><HEAD></HEAD><BODY><P></P><P>wow, that is slicker than snot on a doorknob!</P><P></P><P>*.xml loaded up all 43 files one after the other and concatenated them. Thanks!</P></BODY></HTML> Tue, 23 Feb 2010 16:47:42 GMT https://community.qlik.com/t5/QlikView/command-line-and-v-switch/m-p/156184#M32145 gardan 2010-02-23T16:47:42Z