I have designed a workflow in Alteryx which is supposed to take as input an excel file, then run a series of formulas, filters, sorts and regular expressions at the end of which in order to check a condition I use the summarize tool to count a value in a column and if that value is greater than a threshold then a decision is made. I run the same workflow for 100 files and overwrite the output on the same hundred files. My problem is when I run this workflow by using *.xlsx for those 100 files what happens is the count keeping adding up for each file which leads to an error in the decision. For example when the output is written in the first file the count is 7 which is correct. But when the output is written for the second file the count becomes 14. This is wrong. The real count for the second file is 7 but since this is the second file the count column did not start with zero it started with 7. And the count keep adding up for the subsequent files. The workflow runs fine for one file at a time but when I run it on multiple files it adds up.
Any help is greatly appreciated thanks a lot!
