topic Re: Unzip Files in a Folder to Destination folder in QlikView

Unzip Files in a Folder to Destination folder

munna1317 — Thu, 16 Feb 2017 08:35:25 GMT

Hi all ,

i have 10 Zip files in path "C:\Users\AllamHarish\Desktop\ZIPPPP\*.zip"

Here i need to Unzip Files and paste in path "C:\Users\AllamHarish\Desktop\ZIPPPP"

Please help me out with Qlikview

Thanks in advance ,

Harish

Re: Unzip Files in a Folder to Destination folder

vardhancse — Thu, 16 Feb 2017 08:42:24 GMT

How to unzip files in qlikview ?

Re: Unzip Files in a Folder to Destination folder

munna1317 — Thu, 16 Feb 2017 08:43:50 GMT

hi Sasi ,

Thanks for fast replay ,

I have checked this code , but it is for Single ZIP file how to get 10 Zip files on a Click

Thanks in Advance ,

Harish

Re: Unzip Files in a Folder to Destination folder

rahulpawarb — Thu, 16 Feb 2017 12:10:07 GMT

Hello Harish,

Hope that you are doing good!

You can refer below given sample PowerShell script (I am not good at writing PowerShell scripts; compiled it using multiple website):

$fso = new-object -com scripting.filesystemobject
$folder = $fso.getfolder("C:\Users\AllamHarish\Desktop\ZIPPPP\")
foreach ($f in $folder.files) {
  set shellApp = CreateObject("shell.application")  
  set zip = shellApp.NameSpace("c:\users\petter\downloads\testzip\" + $f.name)
  set dest = shellApp.NameSpace("c:\users\petter\downloads\testzip\")  
  dest.Copyhere zip.items() , 20
}

Regards!

Rahul

Re: Unzip Files in a Folder to Destination folder

munna1317 — Thu, 16 Feb 2017 13:09:42 GMT

Hi rahul ,

Thanks for Replay , i also dont know how to Execute Code for Power Shell .

Can you please guide me how to Run this code .

like for example for CMD promt

We will write Execute Cmd.exe follwed by Scripting .

For Powershell How to Execute please help me out of this , it is Priority Task please .

Thanks in Advance ,

Harish

Re: Unzip Files in a Folder to Destination folder

munna1317 — Thu, 23 Feb 2017 10:28:02 GMT

Solved problem We should have Unzip .exe file then

execute cmd.exe /C unzip -o Source\*.zip -d Destination ;

thanks for All