This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've a set of data files with a date prefix. I'd like to process each file individually fully through a workflow (carrying out Market Basket Analysis) and then write out individual output files from the analysis along with the date prefix. My ideal user input would be a start date and number of days (e.g. 30/10/2016 and 4).
I've seen various bits of generic advice referencing iterative macros, dynamic inputs and batch macros, but none seem to cover it. I feel like it should be straightforward, but I'm struggling to achieve it. The files will be very large, so I need to process each file individually.
Each file will contain many rows of items along with their corresponding order ID to run through the inbuilt Market Basket Analysis R tool. I want to export the rules from the MB Inspect tool to files named:
Many thanks for your help, really appreciate it. In the end I found what appears to be a simpler solution as it does not need a dynamic input. After the Generate Rows tool, I placed a formula tool to create the full filepaths of the input and output files, appended with the dynamic elements:
I then placed my full workflow for the market basket analysis inside a batch macro and used a control parameter along with action tools (update input data tool & update output data tool) to update the input and output files for each iteration.
As the inputting and outputting of the files are within the batch macro there's no need to pass the filename through the workflow which simplifies things massively.