Total Row causing an error in Output

Question

Hello All -

I have a table to which I have added a total row using the cross-tab tool. The problem is now I'm getting an error on output "you must specify a sheet name" and I think it's because the total row just says "TOTAL" in the column where my file path and sheet name should be. I've got the full path set up in the formula tool and the setup in output is also correct. The output requires that the path be on every row of data. Is there a workaround for this?

apathetichell · Answer

could you post a screengrab of the error? Sometimes you'll get an error even when a workflow (mostly) works. Also there could be little things off on the filepath or on the excel output options which would be impossible to see on the workflow screen grab.  That would be much more relevant.

Finally - My take on all of this is that turning things into tables and then union/render would probably be easier and less error prone in the long run.

KateC · Answer

I already have the file path and sheet name assigned. It's not creating the file because that one row says "total" instead.  I moved the formula creating the file path to the end of the workflow but that didn't work either. So I deleted that last output tool and now I'm getting exactly what I want which makes no sense because I've not specified anywhere in the workflow that I want that whole top section to go anywhere. I was expecting only two sheets from the output tools on the left; instead I got all three, and the third one is even called Summary. ??  Not complaining but I don't get it.

dougperez · Answer

I think there's no workaround this... You will have to create a filepath/name...