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 think what you're trying to achieve here is an iteration where you create a running total of Count until 3000 is hit, then you put those records in a file and create the next running total for the next file.
To do this, I've built a simple iterative macro:
This creates a running total until the total goes over 3000. It then sets the running total to zero for those with a higher number and iterates them to the next run. The ones that fall within 3000 are given the first file number and passed out of the macro.
This repeats until they are all in a file.
The workflow takes the macro output and simply creates a dynamic filename, which you then use in the output tool as the output full path:
Thank you for this - but i am unable to import as my company has not yet updated to the most recent version of Alteryx and i can't import it. Is there a way around this (short of installing the update?)