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 NumberProductPriceCreated Date10001C1.0212.03.202210002E14.3608.05.202210003A6.8718.02.202210004C11.0730.05.202210005D12.3309.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 NumberProductPriceCreated Date10001C1.0212.03.202210002E14.3608.05.202210003A6.8718.02.202210004C11.0730.05.202210005D12.3309.04.202210006B15.2811.06.202210007E38.8814.06.202210008A4.2123.06.202210009A5.2401.07.202210010C15.8320.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

Date Stamp Log for Next Workflow

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

Developer

Accepted answers

Robin_McIntosh

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.

Discussion_Run_Date_Log.yxmd

Run_File.txt

All comments

Robin_McIntosh

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.

Discussion_Run_Date_Log.yxmd

Run_File.txt

FreeRangeDingo

I was going to suggest writing to a text file and using the text file as an input, similiar to what @Robin_McIntosh said.

RDF25087

@Robin_McIntoshthank you for the response - I have added your solution to my own data and it runs perfectly. Many thanks!

RDF

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335