Return
-
Title
When using Export to File activity in automation, pivot table lose format -
Description
An export to file activity is created in automation.
The exported data will be saved in an existing Excel file that contains a pivot table.
The Excel file contains two sheets:
- Sheet DATA: It contains the data to be exported.
- Sheet B: It contains a pivot table created from Sheet DATA. The option "Add this data to the Data Model" has been selected, so the pivot table will be refreshed automatically
When the export completes, the data is exported on Sheet DATA but the pivot table of Sheet B disappears.
-
Cause
Unsupported. -
Resolution
WORKAROUND:
If data needs to be added, it needs to be appended to the same worksheet area that the pivot table is based. Adding to a Data Model is not supported.
-
Defect ID
QAT-9565 -
Additional Information
You can define the pivot with data in separate worksheet and clear only that worksheet and export the data or append to existing data in a worksheet. http://www.toadworld.com/products/toad-data-point/m/media-library/1142