Internal error: Unexpected error in table

[bthursti]

I am receiving an error while trying to create a pivot table in the table preparation add on. I do not know how to fix the error and it is not giving me any more information, would someone be able to help me with the following error I have attached? Internal error: unexpected error in table.

Thank you

[binu_acs]

@bthursti Can you provide the workflow in the zip format so that the input files will be included (options-Export workflow)

[bthursti]

Sure, let me know if this didn't work. 

[DataNath]

Hey @bthursti, if you disable AMP engine in your runtime settings, does that help?

Seems to work after running that:

Whilst the Table tool has been converted without comment, this may be something to do with the behaviour of the Cross-Tab tool whilst AMP is enabled:

https://help.alteryx.com/20223/designer/tool-use-amp

[bthursti]

That did, Thank you!

[binu_acs]

@bthursti Another option add a new table tool and try again, that working for me

[bthursti]

Thank you. How do I export this pivot table into an Excel file?

[bthursti]

Do you know how to export the pivot table into an excel file?

[binu_acs]

@bthursti Add a render tool and in the render tool configuration output mode - select choose a specific output file and give the path in the output file option with the excel file name

[bthursti]

@binu_acs Is there a way to do this within an existing file? When I chose the file I want it outputted to it wants to replace the whole file and lose the current data in it.