Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!

Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Introducing Alteryx Marketplace

Easily access verified, supported, and secure Add-Ons.

LEARN MORE
Comments
LATHROPS
7 - Meteor

I tried your tool this morning, I love the idea and hoping to make it work for me.  Currently I am performing some analysis on journal entries and summarizing by company code outputting around 80 excel spreadsheets for management review.  The workflow failed initially, I believe, due to tool 23 (regex) having a variable length of 27.  I updated the length to 255 characters and the error from tool 23 disappeared, however, the workflow then errored because the file path & file were not created.  I suspect it has to do with how the sheet name is specified ("path\filename.xlsx|||sheetname"), but that's my best guess.  Any ideas? 

 

Thanks!

 

Sam

 

TheOC
15 - Aurora
15 - Aurora

hey @LATHROPS 

Sorry to hear about your issue, and great spot on the 27 variable length - i have fixed that now, and will reupload the tool as a new version.

Regarding the file path - I have tested it with a file path as: path\filename.xlsx|||sheetname, and it works fine on my machine. Within the Formula tool (Tool 26), it should have a new field 'New folder' which is the path of the folder without a file:

TheOC_0-1653489203818.png



Are you able to test one of the file paths that did not create, by opening the macro (right click, open macro), and pasting one of them into the macro input of the tool after hitting 'Edit Data':

TheOC_1-1653489257632.png



and then hit run inside the macro, just to see if that file path carries through the macro correctly. It should look similar to my first screenshot by the time it hits my create folder batch macro.

 

If you have no luck, I'm more than happy to jump on a call.

 

Thanks,

TheOC

 

 

 

LATHROPS
7 - Meteor

I ended up going with the Run command to generate all of my folders during a "workflow prep" stage.  I suspect the errors I received from the macro were likely related to how I'd formatted the path for the file.

 

In other news, what led me to your macro was the dilemma around ensuring my folders existed prior to the workflow trying to place folders in the locations specified.  I created my folder creation workflow in parallel to the journal entry analysis workflow. After sleeping on it, I solved my workflow execution sequence dilemma by joining my folder name input with a record ID, feeding the joined results to a select statement "command" field which writes to a ".bat" using the run statement.  Between the select statement and the run statement I have a "Block until Done". I then used a Select record statement for the first record of the command line which appends to the original data set and is then fed back into my workflow (I deselect the command column later). I used the IF NOT EXIST <path> MKDIR <path> to deal with preexisting folders.  It's not the most elegant, but it works!

 

I will likely use your macro again in future workflows, I suspect I messed up my file path.  Well done!  

 

LATHROPS_0-1653493882792.png

 

EG_GBM
7 - Meteor

When I use the Macro, I failed to create all the folder, have 4 but only create 2.

Evaguan_1991_0-1658802839873.pngEvaguan_1991_1-1658802864972.png

But in the workflow, the output for Macro are integrity to 2669.

Evaguan_1991_2-1658803723529.png

 

I don't know why it happened.