Pivot Table appears blank in Results section

Jiyajijp

Forums

Hi Brian
I created pivot table and when I run the dpack the pivot table does not shows in the results section in select and run. It shows a blank table. How can I display the pivot table in Result section while running the dpack.

 

Brian Element Thu, 05/17/2018 - 06:02

Hello Jiyajijp, had to think about this for awhile.  Pivot Tables are generated as results so they would show up in the select and run as it only shows the files.  Probably the only way to do that is to send the pivot table to an IDEA database and then it would be an IDEA file versus a result.

Is this an SA app that you are creating?

Brian

Brian Element Tue, 05/22/2018 - 08:00

When you create a pivot table there is an option to send it to an IDEA spreadsheet, this way it would be another IDEA table that you can then reference from SmartAnalyzer.

task.ExportToIDEA True