Output tool is not refreshing attached excel

Question

Hi Team,

In a WF, I am writing results in mutiple tabs of same excel spreadsheet. To avoid result writing issue, block until done has been used with each output tool.

Good part is, in first attempt, wf writes result in all tabs of excel spreadsheet. But, issue is, when I re run WF then it is not refreshing/overwriting results in excel sheet. In other words, it is not refreshing excel sheet.

Note:- with output tool, I am already using setting as to overwrite sheet.

Kamran1991 · Answer

Can you please share the sample workflow with dummy data?

ArtApa · Answer

Hi @Vikas038 - Please provide a workflow sample or reach out to support@alteryx.com with all the details.

Tanai_Goncalves · Answer

Hello,

Not sure of all your details, but the “Block Untill Done” tool will work fine only if your output path is in the same instance of your alteryx designer machine.

i.e: C:user/alteryx/output-path

If your output path is located in another server (different from the Designer machine) the block untill done tool may not work fine due to two different processing queue (your machine queue and the server file queue).

i.e: //serverfile/alteryx/outputpath

Not sure if that’s the case.

regards,

Tanai