Create a folder based on the field values

[dineshbabu2811]

Hello All,

I have a table where it has 2 columns employee Name and Department, My requirement is to create a folders based on the department and generate excel output in that folder with respect to department and employee Name.

I tried to create a folder using bat file its creating successfully, but my bat file still remains in that folder so it might be risk or junk file for end users.

How to create the folder and delete that bat folder using Alteryx version 2020.1

could some one advise on this to resolve it.

Thanks
Dinesh

[jdminton]

You should be able to add a separate Run Command tool after the process has completed to delete the .bat file when complete.

[dineshbabu2811]

Hi @jdminton - could you please provide a sample workflow it would be more helpful

[jdminton]

@dineshbabu2811 it is one tool - not a workflow. If you'd like to share yours, I can add the tool. Otherwise, here is a reference:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Batch-Files-in-Alteryx-Part...