Macros

aparna0208

Hi,

I have no clue about macros and I did see some articles and videos but not able to understand if I can use macros for my logic. I already have a workflow in place to process some excel files where it does bunch of different things. I have to process files one by one with this workflow. I was thinking if there is a way to process all at once. That's when I started playing around with tools and I found this directory tool. This reads all the files in a particular folder which is fine. Now I'm trying to see if there is a way to read all files at a time but process it one by one from start to end through the existing workflow.  Each file from the location needs to go through the whole workflow before moving onto the next file rather than bringing in all of the files together and then run them as one output before splitting out each file right at the end. So I was wondering if this is something that could be achieved with the help of macros. Looking for some help! Thanks in advance.

Meet_Nandu

Hi @aparna0208! 

First, you would have to create a macro of the workflow you want to run multiple times. So, you can create the macro by selecting the macro option in configuration pane, like below - 

After, you have selected this option, you will have to add two new tools - Control Parameter Tool and action tool (the ones in black)

The control parameter tool will read the path of each file one at a time and the action tool will update the path of the input tool with the value that comes from the control parameter tool. You will have to give the configuration of the action tool somewhat like this - (Please don't forget to tick the replace a specific string at the bottom)

You can then add your existing workflow after the input tool. Once you save this, it should be saved with a .yxmc extension. 

After this, create a new workflow as below - 

 In the input directory tool, give the input of the folder where all your files are located. The formula node is not necessary. (I needed it because I wanted to write the files in a different folder) Then you will have to import the macro you created by right clicking on the canvas and then selecting insert and then the last option should be macro. (You should import the .yxmc file you created) The macro will ask you to select a field for the control parameter tool. You must select the option FullPath. This way the macro will be fed the full path of each .xlsx file you want to run. 

Hope this helps you! If not, feel free to contact me via LinkedIn or private message me here.