Get all files to write regardless of data prior to end of Alteryx flow

dsandmann

Hi All -

Having an issue outputting data to excel sheets. I'm reading an existing template (has calculations and formatting) into the working directory where I then output data to that template. 

Sometimes, the output data tool will end up having no data to that sheet as a result of filtering. In these cases, it seems like Alteryx waits until the end of the flow to output the 0KB sheets regardless of where they fall in the flow and any blocking/waiting that I do.

This is an issue because the empty output acts as a "format" and leaves only headers in the sheet, and at the end of the flow I am using run command to move files around dependent on whether the user/creator wants the file to download from gallery or sent in an e-mail. If the empty output waits until the end, the run command moves the file and/or an e-mail is sent while the sheet isn't formatted, then a small file is created in the place I just moved one from when it does finally run.

I can't really use an event either, as I'm writing the part that moves files as a macro (that includes an e-mail batch macro that allows different numbers of attachments) to be used in multiple flows.

I'd really like a way to force all the files, even if only containing headers, to complete writing before my end process without having to add a tool to every output if someone knows a way to do that.

Thanks!

AkimasaKajitani

Hi @dsandmann 

I tried and confirmed it as you said. I knew the behavior at this time.
In this case, you can use container tool.

Firstly you put Output Data tool into the container.
When the record is zero, you make the workflow that disable the container to not write the zero data. So the Data Output tool will not work.

You need to use batch macro in this case.

Sample macro :

The workflow that calls the macro : 

Please check the uploaded workflow.

ExcelHeaderOnly_sample.yxzp