<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic creating batch file from qlik sc in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/creating-batch-file-from-qlik-sc/m-p/95873#M15406</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i am trying to create a batch file from qlik script to create a folder and move the files from one folder to newly created folder.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;let vToday = text(date(Today(),'DD_MM_YYYY'));&lt;/P&gt;&lt;P&gt;set&amp;nbsp; vCreateFolder = 'Execute cmd.exe /C mkdir "C;\TEMP_DELTE_QVD\QVD\$(vToday)";';&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Batch_Generate:&lt;/P&gt;&lt;P&gt;LOAD * INLINE [&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; @Echo&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Rem &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; $(vCreateFolder)&lt;/P&gt;&lt;P&gt;];&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;store &lt;SPAN style="font-size: 13.3333px;"&gt;Batch_Generate into &lt;SPAN style="font-size: 13.3333px;"&gt;Batch_Generate.bat(txt);&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;this is generating batch file but this is not creating folder because batch is creating script as below&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;@Echo&lt;/P&gt;&lt;P&gt;Rem&lt;/P&gt;&lt;P&gt;"Execute cmd.exe /C mkdir ""&lt;SPAN style="font-size: 13.3333px;"&gt;C;\TEMP_DELTE_QVD\QVD\&lt;/SPAN&gt;11_10_2018"";"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;it is appending double code in before execute and before folder path.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;could somebody help me with this.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;$@M.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 11 Oct 2018 11:27:21 GMT</pubDate>
    <dc:creator>mightyqlikers</dc:creator>
    <dc:date>2018-10-11T11:27:21Z</dc:date>
    <item>
      <title>creating batch file from qlik sc</title>
      <link>https://community.qlik.com/t5/QlikView/creating-batch-file-from-qlik-sc/m-p/95873#M15406</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i am trying to create a batch file from qlik script to create a folder and move the files from one folder to newly created folder.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;let vToday = text(date(Today(),'DD_MM_YYYY'));&lt;/P&gt;&lt;P&gt;set&amp;nbsp; vCreateFolder = 'Execute cmd.exe /C mkdir "C;\TEMP_DELTE_QVD\QVD\$(vToday)";';&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Batch_Generate:&lt;/P&gt;&lt;P&gt;LOAD * INLINE [&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; @Echo&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Rem &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; $(vCreateFolder)&lt;/P&gt;&lt;P&gt;];&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;store &lt;SPAN style="font-size: 13.3333px;"&gt;Batch_Generate into &lt;SPAN style="font-size: 13.3333px;"&gt;Batch_Generate.bat(txt);&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;this is generating batch file but this is not creating folder because batch is creating script as below&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;@Echo&lt;/P&gt;&lt;P&gt;Rem&lt;/P&gt;&lt;P&gt;"Execute cmd.exe /C mkdir ""&lt;SPAN style="font-size: 13.3333px;"&gt;C;\TEMP_DELTE_QVD\QVD\&lt;/SPAN&gt;11_10_2018"";"&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;it is appending double code in before execute and before folder path.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;could somebody help me with this.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;$@M.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 11 Oct 2018 11:27:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/creating-batch-file-from-qlik-sc/m-p/95873#M15406</guid>
      <dc:creator>mightyqlikers</dc:creator>
      <dc:date>2018-10-11T11:27:21Z</dc:date>
    </item>
  </channel>
</rss>

