Output in Excel files

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

Error Message

Accepted answers

nagakavyasri

@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

All comments

Raj

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

hope thishelps.

AlexZ91

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.

block until done.png

AlexZ91

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.

Alteryx BUD.png

nagakavyasri

@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

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235