dynamic table o pivot table

3 posts / 0 new
Last post
ortizmario6025@...
Offline
Joined: 09/03/2021 - 11:54
dynamic table o pivot table

Hello, I am creating a pivot table in idea, and the script runs fine. The question is, how do I send this table to Excel through other scripts, since IDEA does not save it. any idea how to do it?, I want to automate all the tasks, but this is a small problem.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

You would have to first export it to IDEA which you can do through the pivot script and then take the IDEA file and export it to Excel.  There are limitations in thet you can only have one field selected as a row and a column, if you have multiple fields I don't think you can perform an export to IDEA.

ortizmario6025@...
Offline
Joined: 09/03/2021 - 11:54

Yes, I have tried, I will look for another way, thanks