Return
-
Title
Exporting a pivot table with column data repeated on each row -
Description
When customer attempting to export a pivot table, they have a user that requires the data to repeat on each line. Attach the spreadsheet test example. They are using version 4.0 and he stated prior to 3.6 being uninstalled from his machine he was able to export in the manner he wanted. In the example, yellow represents what he has and green is what he needs.
-
Resolution
Our main enhancement for TDP 4.3 is on the Pivot Grid. One of the features is to export the data as a flat grid which is the main feature the user is asking for. Please ask the user to try the current Beta. I have attached screenshots on what we currently have.http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program/What we do not have is an option to add to the Data Model. There is no API call for this so we can't-do this programmatically. Is the user just trying to hide the data tab? It that is the case we could see about adding that option. We are very near to RTM so not sure that would make it into this release.Also, note that we have better export to Excel Pivots, as well as saving flat grids to local storage and publishing to TIC. Hope this help.