Write one record to Excel

[Brad1]

I want write a record that is created in Alteryx to Excel each day.  Each day I want the new record to drop below the one above it in Excel.  Thanks for any help in advance.

[gsaval · Accepted solution]

Hello,

For Excel, you will need to overwrite the file not necessarily add to it.  Here as an example adding a new line that increments by 1 each time you run the workflow.  In the attached example I:

1. Input the Excel file
2. Use a Block Until Done tool to make sure the file is completely input before trying to override
3. Use the Summarize tool to get the last line
4. Use my formula to create the new line
5. Union this new line on the bottom of the original dataset
6. Then output a new file that overwrites the original

Hope this helps!