Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Output in Excel files

AlexZ91
5 - Atom

Hi,

I am building a workflow and I need to record 2 outputs:1 data output before a data transfomration in an Excel tab and another data output after the data transformation in another Excel tab but the same Exel file). When I run the workflow, I get an error: the excel file is used by another process and can not be opened. I tried to use th container, but it is not working.

 

Can someone help me out ?

 

Thank you.

Alex

4 REPLIES 4
Raj
16 - Nebula

@AlexZ91 
use Block until done before writing second output
this will solve the issue

hope thishelps.

AlexZ91
5 - Atom

Hi Raj.

Thanks for your suggestion. I have been checking how to use this function, but it is still confusing.

 

In this workflow attached, where should I place the block untill done function ?

 

Thanks.

 

AlexZ91
5 - Atom

Hi Raj,

I tried this at the end of my whole process. So the idea is

- to write into excel sheet 1 at anchor 1

- once finished, write into the same excel but in sheet 2

- once finished, write into the same excel but in sheet 3

 

When I run the workflow, it seems that the whole process stops at the entry of BUD and not writing at all any excel sheet. Is there anything wrong ?

Thank you.

 

nagakavyasri
12 - Quasar

@AlexZ91 Guess the process is actually taking time but not stopped after writing to 1st output, the process has to join and then write to 2nd, 3rd outputs. 

 

You can use all the joins before 'Block until done' tool and then output tools at the end.

 

Screenshot 2024-10-22 115813.png

Labels
Top Solution Authors