Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
munna1317
Creator II
Creator II

Unzip Files in a Folder to Destination folder

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

1 Solution

Accepted Solutions
munna1317
Creator II
Creator II
Author

Solved problem We should have Unzip .exe file then

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

thanks for All

View solution in original post

5 Replies
vardhancse
Specialist III
Specialist III

munna1317
Creator II
Creator II
Author

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

rahulpawarb
Specialist III
Specialist III

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

munna1317
Creator II
Creator II
Author

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

munna1317
Creator II
Creator II
Author

Solved problem We should have Unzip .exe file then

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

thanks for All