community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Write one record to Excel

Bolide

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.

Highlighted
Alteryx Certified Partner

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!

Labels