Output issue

Question

Hi, I have a workflow that has multiple outputs to the same file but separate tabs. Each of the outputs are connected properly using control containers and it was all working previously but I have one output that is not appearing in the excel file despite getting a msg in the results screen saying the records have written successfully.  I have tried to add a separate output to a separate file to see if that works, but it is not flowing the date to the output. Can anyone suggest how I can trouble shoot this or what can be  that is causing it?

Pilsner · Answer

Hello @Carlyn

I think @jrlindem  and @garyfraga255 have covered most of the steps I would follow to try and diagnose the issue well. I just wanted to add a comment about cell ranges.

Apprechiate this may not be applicable but if you are outputting to a specified cell I have had a similar issue to the one you described. In my case, the issue was due to the range I provided being too small. You need to make sure that the cell range covers enough columns and records to contain all of your data. If not you will likley have issues with the ouput.

If you are still having issues, please could you send a screenshot of the data going into the output tool, along with the configuraiton.

I hope this helps.

Regards - Pilsner

garyfraga255 · Answer

@Carlyn wrote:Hi, I have a workflow that has multiple outputs to the same file but separate tabs. Each of the outputs are connected properly using control containers and it was all working previously but I have one output that is not appearing in the excel file despite getting a msg in the results screen saying the records have written successfully.  I have tried to add a separate output to a separate file to see if that works, but it is not flowing the date to the output. Can anyone suggest how I can trouble shoot this or what can be  that is causing it?

Hello,
Check the output tool configuration—verify sheet names, overwrite/append settings, and file path. Also confirm no downstream errors or locked file access; testing with a fresh file often helps isolate the issue.

Best regards,
Gary Fraga

jrlindem · Answer

I would start by double checking your formulas.  The instructions that are being used to specify the output.  For the partition that's not working, try and shut off all the other pieces of your workflow and just run that one stream to see if it writes when it's on it's own.  If it does, then you may need to consider adding a little bit of time in between the control containers using, for example, the CReW Macro:  [Wait A Second]

Sometimes when the different streams of control containers run really fast, they can still collide as your Alteryx/Excel is trying to finish up the write and close out of the file (for example).

But I would start with ensuring the output write instructions are correct by isolating it down first.  Hope that helps, -Jay