Output issue

[Carlyn]

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?

[jrlindem]

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