24313_en-US

liliconcom

Categorical> Ease of use> Export multiple reports to excel at one time

Categorical ease of use request:  when I have multiple tables in categorical, exporting them to excel will only export the top one. I can collapse that and do another export to get the next one, and so on, but that's pretty awkward. A choice to export them all together would be more efficient.

 

Clarification from @reese_sj below:

During an analysis, I would create several scripts that I use for insights (screen shot of several breakout reports).  The idea is that each of these scripts is slightly different, but typically there could be a large variety of categorical reports and I would need to export each one into excel for various reasons.

Re: Categorical> Ease of use> Export multiple reports to excel at one time - Status changed to: Open for VotingRe: Categorical> Ease of use> Export multiple reports to excel at one time

This request was repeated in EXPORT to XLS.

Re: Categorical> Ease of use> Export multiple reports to excel at one time

This is probably best handled by a custom script/add-in that examines the scripts in your data table and executes the Categorical scripts and then exports the tables to Excel.

 

I don't think this is something we could build into JMP itself since there are many different kinds of scripts that could be attached to a data table, and such a utility wouldn't be of use to most JMP users.

Re: Categorical> Ease of use> Export multiple reports to excel at one time

 

During an analysis, I would create several scripts that I use for insights (screen shot of several breakout reports).  The idea is that each of these scripts is slightly different, but typically there could be a large variety of categorical reports and I would need to export each one into excel for various reasons.  Thanks,

Scott

 

 

Re: Categorical> Ease of use> Export multiple reports to excel at one time - Status changed to: Needs InfoRe: Categorical> Ease of use> Export multiple reports to excel at one time<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Make sure you're right clicking on the blue triangle to the left of the outline node. The same place you'd left-click to open or close the node.

Re: Categorical> Ease of use> Export multiple reports to excel at one time

Jeff-

Here is what I am referring to- I have a script for each report I have created and would like to build and export quickly.

Regarding your example to open all nodes, I am right clicking but getting a different option list. Any suggestions?

Scott

Re: Categorical> Ease of use> Export multiple reports to excel at one time

In a categorical report like this:

the option Save Tables -> Save Excel File from the hotspot menu in the Categorical outline node will saves only the open outline nodes to the Excel file (I believe this was a request from P&G to work this way). If you have multiple outline nodes open it will save all the open ones.

You can quickly open all the nodes by right clicking on the blue triangle next to the Categorical outline node and choosing Open All Below.

If this is sufficient here, please reply here and we can edit this idea to mark it appropriately.

Thanks!