Internal error: Unexpected error in table

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

Inventory Adjustment Report.yxmd

Workflow

Settings

Tableau

Accepted answers

All comments

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.

Inventory Adjustment Report.yxzp

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.

binu_acs

@bthursti I don’t think that is possible with the render tool, one option you have to create all your data using the existing workflow along with the pivot then output to excel file using the render tool , another option instead of using table tool write the output directly to the excel sheet using output tool, in this case you will not loose your original data

bthursti

@binu_acs so you can not export more than one pivot table into the same file? is that what I am understanding?

binu_acs

@bthursti I mean to say if you are writing your pivot to the existing excel file then it will replace the existing data. If you have multiple pivot you can write all those data in the excel output

bthursti

@binu_acs how do I write all of the pivot tables into the same excel file?

Inventory Adjustment Report.yxzp

binu_acs

@bthursti Same excel file with different tabs?

bthursti

@binu_acs Yes that is what I am trying to accomplish.

binu_acs

@bthursti Yes, that is possible, I will update your workflow and send it back to you

binu_acs

@bthursti Attaching the updated file, you need to make the changes in the table tool, below is the output generated from the updated workflow

Inventory Adjustment Report.yxzp

sowjanyayinti

Is there an internal bug or is it an issue with the way we are using the pivot table feature? I am receiving the same error as the OP so decided to re-open this old thread.

I do not get the error if i turn off the AMP engine but i cannot use control containers if i turn off the AMP engine. Soooooo what gives?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703