Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Update some of the data filed by conditions

187
8 - Asteroid

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?
 

2 REPLIES 2
binu_acs
21 - Polaris

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

binuacs_0-1675839821094.png

 

 

187
8 - Asteroid

@binu_acs  THIS IS WORKING THANKS A LOT!

Labels
Top Solution Authors