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'm working in a workflow that compares two files, one is ingested monthly and is filled with a budget for different items, the second file is ingested daily, this file has the same items IDs as the monthly one, but instead of a budget the file contains the daily spending for each item, the idea after the ETL is to set an alarm (email,sms,tweet) when the daily spent is 25%, 50%, 75% and 100% or more of the budget, so far so good, I'm good with the ETL, the formulas to flag the items in the different scenarios and the alarms, but what I can't figure out is how to store the daily spent, I need to save today's spent in order to sum it with tomorrows and so on to compare this with the budget.
The best scenario is save everyday results in a database but I have no access to a database yet so I'm tied using excel files. I was thinking in output this files and then read it in bulk, does anyone have a better idea?.