How to export single row of statistics?

[nrossin]

I have a workflow that outputs to a database. I need to add another output to append to an Excel sheet that functions as a log of sorts.

The data exported to the spreadsheet should be a single row, containing a value from the main dataset, the total count of rows in the main dataset, and today's date.

I have tried several ways of doing this using the Summarize and Count Records tools, but I can't get the additional fields from the main dataset to be included.

For example, suppose this is my main dataset (the "Report Date" column will always contain the same value for each row):

+-------------+------------------+---------------+--------+
| Report Date |  Customer Name   | TransactionID | Amount |
+-------------+------------------+---------------+--------+
| 2019-11-01  | Roy Scheider     |             1 |  43.22 |
| 2019-11-01  | Robert Shaw      |             2 |  81.04 |
| 2019-11-01  | Richard Dreyfuss |             3 | 569.14 |
+-------------+------------------+---------------+--------+

Now, I need to export a single row that contains the Import Date, today's date, and the total # of rows:

+-------------+-------------+--------+
| Import Date | Report Date |  Total |
+-------------+-------------+--------+
| 2019-11-15  | 2019-11-01  |      3 |
+-------------+-------------+--------+

How can I do this?

[Jonathan-Sherman · Accepted solution]

Hi @nrossin,

Is this what you're looking to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[nrossin]

Yes, exactly! I needed to see how you configured the Summarize tool because I could not grasp that part. Thank you.