Export to excel, keep fomular and update the data

[Zhiting]

Status1:  column A to E are the insert data, F has fomular 

and then alteryx export/ update it with only column A to E

How do I get the following status, column F withfomular  still present and automatically calculated ?

[SPetrie · Accepted solution]

There are a couple ways you can go about it. First option, you output to just a specific range that excludes the formulas (Alteryx will not let you overwrite formulas). In my test file I used columns C and D so my output would be columns A to D with the formulas being in column E.

The other option is to rebuild the formulas inside Alteryx.

I used a RecordID tool starting at 2 to generate row numbers and then created my formulas using it. In this method, you would just overwrite the entire sheet and the formulas you generate are the ones that are entered in the appropriate column in excel.

I attached an example workflow using both methods.

Hope this helps!

[Zhiting]

Thanks!