Scripting the same output for all levels of a categorical variable

Question

Hi,

I have a script that performs some calculations, runs some platforms and extracts certain output, and then builds a tab box in a new window. I want to do all of this for each level of some categorical variable that the user specified in my dialog box.

Currently I create individual subsets of the data based on my grouping variable, and then loop through each of those datasets:

dtSubset = dt << Subset( By( Eval( groupVar ) ), Linked, Selected Columns Only( 0 ), All Rows( 1 ), Invisible );

For( i = 1, i <= N Items( unique_groups ), i++,
dt_i = dtSubset[i];

...some code to do stuff
<BR />...append output as a new tab box in my window
);

Essentially all I am doing is coding up my own analysis and wanting a 'By' variable. I am wondering if there is a better or more efficient way to go about this? The main thing I want with the code is to have the output I create be specific for each level, while also still maintaining a connection to the original data table (meaning the plots in my output are interactive still).
 
As you can see, I create the subsets as Invisible and then within my code I close them at the end of each iteration of the loop.
 
Thanks,
Robert

jthi · Answer

If you append them like Jim did demonstrate, they will end up loosing the interactivity. Subset/Where do both work quite well but there are cases where you are not able to utilize Where that easily such as creation of summary tables (it uses local data filter instead of simple Where). And with subsets you can potentially end up with a lot of data tables you might have to deal with as they might not close as you expect them to (when closing the main table). Sometimes it might also be worth considering to use Local Data Filter as you use one filter for multiple platforms with Data Filter Context Box.

rcast15 · Answer

Thank you both for your input, the code provided all works well. I should add that I am building a fairly complex add-in that pulls from a lot of different platforms and creates some novel output as well. What I really wanted was to ensure my plots and tables that are normally linked to my data table to remain that way. I also wanted every single tab to look the exact same, so looping seemed like an easy fix.

Do you think the best way to go about this is to just use the By option in all the platforms I am using and then loop thru the levels of my variable calling each component using the various paths and appending those where I want them?

rcast15 · Answer

Really the main reason is because I found it simpler to loop through the different levels of my variable and build each tab window that way, then append. Since for each level I am performing calculations for tables, building a graph with graph builder, extracting qq plots from the Dist platform, extracting the studentized residual plot from the fit model platform, etc.