Hi all -
In my mind this sounds simple, and I'll try and explain as clearly as I can what I need...
So, let's imagine I have a simple table of data, e.g.
Contract Number | Product | Price | Created Date |
10001 | C | 1.02 | 12.03.2022 |
10002 | E | 14.36 | 08.05.2022 |
10003 | A | 6.87 | 18.02.2022 |
10004 | C | 11.07 | 30.05.2022 |
10005 | D | 12.33 | 09.04.2022 |
I run my Alteryx workflow on 01.06.2022 and it emails this table to a set of recipients.
Okay, fine I can do that - not a problem.
However, give it a couple of months and my original table has expanded, e.g.
Contract Number | Product | Price | Created Date |
10001 | C | 1.02 | 12.03.2022 |
10002 | E | 14.36 | 08.05.2022 |
10003 | A | 6.87 | 18.02.2022 |
10004 | C | 11.07 | 30.05.2022 |
10005 | D | 12.33 | 09.04.2022 |
10006 | B | 15.28 | 11.06.2022 |
10007 | E | 38.88 | 14.06.2022 |
10008 | A | 4.21 | 23.06.2022 |
10009 | A | 5.24 | 01.07.2022 |
10010 | C | 15.83 | 20.07.2022 |
Now the tricky part....
Next time I run my Alteryx workflow I only want it to email out the above table where the Created Date is greater than the date the last time the workflow was ran (01.06.2022) - so it should only email out a table including contracts 10006 through 10010.
I thinking a simple Excel log file?
Any thoughts or more elegant solutions greatly appreciated.
RDF
Solved! Go to Solution.
Perhaps write to a file (Excel or text) each time you run the report; either overwrite so it's a single entry or just keep adding if you need to keep track of run dates. Then pull that file into the Workflow and compare the last date to your records.
Here's an example overwriting the log file. The initial log file has a date of 2022-01-20. Obviously, you'll need to update the Input and Output filepath for your log file.
I was going to suggest writing to a text file and using the text file as an input, similiar to what @Robin_McIntosh said.
@Robin_McIntoshthank you for the response - I have added your solution to my own data and it runs perfectly. Many thanks!
RDF