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 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
@binuacs so you can not export more than one pivot table into the same file? is that what I am understanding?
@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
@binuacs how do I write all of the pivot tables into the same excel file?
@bthursti Same excel file with different tabs?
@binuacs Yes that is what I am trying to accomplish.
@bthursti Yes, that is possible, I will update your workflow and send it back to you
@bthursti Attaching the updated file, you need to make the changes in the table tool, below is the output generated from the updated workflow
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?