Cross Tab with Total Row and Render with Group on Path

Question

Hi Community,

I'm running into a problem with rendering a cross tab. My container for this piece of the workflow looks like this:

I am filtering by the ALS dvision and want to render the results to their network drive. There are 6 other divisions I will need to do this for.

The output from cross tab/rate calculations looks like this when I select both the Sum & Total Row options in the Cross Tab tool :

And the output from the Basic Table looks like this, grouping on Dept & OutputFile:

What I am trying to do is render the data to Excel, using the 'Group Data into Separate Reports' on the OutputFile. I can get it to work IFF I remove the Total Row option from the cross tab. If I leave it in I get the dreaded

"Error: Designer x64: The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.". As I would REALLY LIKE to have the Total in the output, can anyone see a work-around?

I've attached the Excel with the 2 tables above.

Thanks,

--sue

Sample For Cross Tab Render.xlsx

SeanAdams · Answer

Hey @YeahMan

This particular error is generally indicative of something else having failed - and often the Alteryx Engine has crashed.

For example - @mbarone wrote up a bunch of things that he was seeing cause this crash here https://community.alteryx.com/t5/Alteryx-Designer-Discussions/InboundNamedPipe-ReadFile-The-pipe-has-been-ended-gt-All/td-p/161194

Two thoughts:

a) This particular case - if you can mock it up with some dummy data and demonstrate the issue - would be great for the support team 'cause then they can debug the cause of the core engine crash.   If you can mockup a dummy data version of this that has the same crash - well worth submitting this to support@alteryx.com

b) If you don't manage to get this right using the configuration you have - you can always put a text box below the main table with "Total : XXX".   It's a bit of a workaround, but you can format it to look pretty good.

YeahMan · Answer

Hi @pedrodrfaria

I've run into a problem with this solution. The path that the output is being written to has changed

from: C:\Temp\ALS\Retention 2020F-2021W_ALS.xlsx

to:     C:\Temp\C__Temp_ALS_Retention 2020F-2021W_ALS.xlsx.xlsx

And the Total Row is being written as a separate workbook, and that is being written to:

C:\Temp\Total.xlsx

So I don't think I will be able to have a Total Row on each sheet in the workbook as I would have liked.

Thank you very much for your assistance and have a nice weekend.

--sue

JagdeeshN · Answer

@YeahMan

Please find attached a workflow that would give you the solution. The issue was with the 'Output File' (Path) for the Total report.

Do let me know if this helps.

Best,

Jagdeesh

Cross Tab with Total Row and Render with Group on Path.yxzp