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 have a user input sheet a user would enter data into excel every day. Instead of looking at the excel sheet every day to see a long list of items. I want to export all of the things that changed from the prior day so I can isolate them. After that is done, I want the input file to export with all changes over the prior day files. However, what I am seeing, is that it is overwriting the prior data first, despite my block until done option.
Mark Frisch from MarqueeCrew resolved my issue through a private message. Key elements provided by MarqueeCrew: - There is no order of operations
- In order to ensure my foodtestprior file pulls earlier, it is suggested that a count records is put next to it, and it is appeneded (just the tool, you can unclick the count in the fields) to the end of the workflow before outputting. - This forces the count before any other steps are made.
Thanks Mark! I'll await your post to verify it as a solution.
Thank you Maskell_Rascal for your post as well. Does your macro do something similar?
Just wanted to say that I love the simplicity of the Parallel Block tool!
But yes, there are definitely times where solving with "standard tools" offers are greater deal of control. I use a Count Records/Append combo in several workflows to check for data before writing to sheets in my output.