Update some of the data filed by conditions

[187]

Hi Alteryx Engineer,

I have req that update some filed base on condition, the way I do this is open the file and use a Formula tool to update the fileds and flush all data immediately to the same file , but it throw out error 
Error: Output Data (3): Unable to open file for write: C:\xxx.xlsx - Attempt to open a file that is already open: C:\xxx.xlsx: The process cannot access the file because another process has locked a portion of the file. (33)

Any advice I can implement this?
 

[binuacs · Accepted solution]

@187 use the Block Until Done tool before writing to the same excel

[187]

@binuacs  THIS IS WORKING THANKS A LOT!