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
@bthursti Can you provide the workflow in the zip format so that the input files will be included (options-Export workflow)
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:
That did, Thank you!
Thank you. How do I export this pivot table into an Excel file?
Do you know how to export the pivot table into an excel file?
@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
@binuacs 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.