Hi all,
I think I have solved my problem, but I'm not sure why what I have done has worked and I was wondering if anyone could shed some light so that I can apply what I've done from a place of understanding.
I was having a problem with the workflow below where the output from output anchor 1 of the leftmost BUD would fail with a 'cannot create backup' error. I've read a few of the posts about the error trying to figure this out, but none of those suggestions worked. I already had a BUD in the workflow (the leftmost one in the image) as I know that Alteryx can't write to a file that is already open.
Having tried swapping the order of the two outputs, the error still occurred with the output from output anchor 1. In desperation, I threw in a random BUD before the first output and this seems to have solved the issue - it ran properly. The question is, WHY?
Firstly, why was I getting the error? I have any number of workflows in which I have successfully used BUDs to output multiple times to the same file within a single workflow. Even THIS workflow worked properly (without the random BUD) until I removed a couple of fields from the 2nd output.
Secondly, why does adding the random BUD make the output work correctly?
For information my outputs all go to a sync'd sharepoint drive. (I'm unable to store anything locally because even my 'desktop' is pointed at a sharepoint drive.) I don't know if this could make any difference, but seeing a suggestion on the forum to save locally made me wonder.
Any insight would be welcomed.
Thanks
PuffinPanic
