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 created a workflow that loads the first month's beginning balance and activity, and then generates the ending balance. What I'd like to do is use the ending balance from that workflow as the beginning balance in the next workflow for the following month. What's the best way to achieve this?
Start out by storing your initial values in a database, either Alteryx .yxdb, SQL, or even a permanent .csv file along with a start date. Set up your workflow to read your initial values from this database, filtering for the most recent records. Process the values and write out the results to the db with a new time stamp . The next month when you run your workflow the process will repeat. Appending the results back into the db gives you an audit trail as well.