Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Saving CSVs in a new folder created and Zipping it

asmit_kumar_pwc
7 - Meteor

Hello All,

 

I have a situation, where I have some CSVs, now what my requirement is, I have to save all the CSVs in a single newly created folder and the Zip that folder. Then I need to upload that ZIP file to SharePoint.

 

I have seen lots of post related to this but didn't find anything which is suitable in my case.

 

Please guide me. Any lead or suggestion will be much appreciated. Thank you so much.

1 REPLY 1
MarcSchonwandt
7 - Meteor

 Hi Asmit,

How far did you get in your efforts on this one? Did you get stuck while zipping the files, creating the folder or uploading to sharepoint?

 

I'd probably recommend:

1) First, I'd run a bat script which execute an 'MD' command followed by the name of the folder you want to generate.  This is lunched by run command tool as you mention.

2) Then run your workflow to generate the csv files. The Block until done tool will help you run in the the right sequence.

3) Then adding your files to a ZIP using @Bharti 's directions here using 7-zip.

4) To upload to sharepoint, you can now use the download tool (link) or use an (S)FTP Macro.

 

Hope the above helps! Let me know how you go mate.

Cheers,

Marc

Labels