Dynamically unzip and read archived CSV file

Hi All,

My first post! 🙂

I've been scratching my head with this problem and I couldn't find what I exactly needed in other posts. I did try this, but for some reason it didn't work - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-input-tool/td-p/321770

So I have monthly zipped files per country that I download.

Each zip file has the rough file structure and I need to unzip them individually.

I've created the following workflow, but keep getting the unable to open archive error

I would appreciate if someone can tell me where I'm going wrong. I'm also seeing the following warming which I'm not sure if it's related?

Warning: Dynamic Input (5): The file "C:\Users\pedram.mahabadi\Documents\Alteryx\PA\Consumption Data\Markets\NL\UPFIELD_NL_YellowFat_arch_06192020.zip|||C__Users_pedram.mahabadi_Documents_Alteryx_PA_Consumption Data_Markets_NL_UPFIELD_NL_YellowFat_arch_07252020.zip___UPFIELD_NL_YellowFat_MKT_07252020.csv" has a different number of fields than the 1st file in the set and will be skipped

unzipper.yxmd

Dynamic Processing

Accepted answers

randreag

Hi @peddy

Change in the dynamic input the last option "Change entire file path". If you check the warning can see that is concatenating both paths and that is why it can be open.

And a recommendation if your fields are no the same in your zips it is better to use a macro, since Dynamic input is very sensible with these differences.

I hope it helps

All comments

randreag

Hi @peddy

Change in the dynamic input the last option "Change entire file path". If you check the warning can see that is concatenating both paths and that is why it can be open.

And a recommendation if your fields are no the same in your zips it is better to use a macro, since Dynamic input is very sensible with these differences.

I hope it helps

peddy

Ah yes!!! This was driving me crazy! Can't believe I missed that - thanks!! 🙂

himani98

Hello All, I am trying to use the online version of Alteryx, which is the Alteryx cloud and trying to upload a .yxmd file to the platform. Upon uploading the file, I am getting the following error : Designer Cloud Powered by Trifacta does not support uploading folders or binary files: "challenge_193_start_file.yxmd". It would be helpful if anyone would be able to guide me through this.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235