I have a horrendous workflow that takes in a number of files, XML and Excel does a comparison, then spits out an Excel document with multiple tabs. for for each check basically, showing the comparison and a Pass/Fail depending on whether the values match between the files. It was/is all working fine however.... The user has now requested that they want to be able to run this for around 20 XML files and want to run it as a batch. So it would create an Excel file (with all the tabs), one for each XML. Ive been playing about with it all day and the issue I have is that each XML file is a fund, so there are 20 funds but when Im using the Parse XML tool, I pull out certain values, say Fund Currency, then check that against the Excel file but if I bring in more than one XML file, the fund name is not in the field that I extract, so what I want to do is run the workflow once for each file, rather than as happens now where Alteryx brings in all the XML files at once. Is a Macro the way to go? Would I simply put my existing workflow 'inside' the macro, passing the XML filename?
