topic Re: create new tables from a stack table in Discussions

create new tables from a stack table

Sebnem — Fri, 09 Jun 2023 22:06:18 GMT

Hello,

I would like to create new tables based on selected rows in "label" column. For example I would like to select rows starting with "Rpp" such as

Rpp_Center
Rpp_North
Rpp_East
Rpp_MidEast
Rpp_MidWest
Rpp_South
Rpp_West
Rpp_North

and create a new table called Rpp. Then, select rows starting with Wig_350

Wig_350_Center
Wig_350_East
Wig_350_MidEast
Wig_350_MidWest
Wig_350_South
Wig_350_West
Wig_350_North

and create a new table called WIG.

Then, repeat this for all the labels .

Can you show how to scrip this?

Re: create new tables from a stack table

jthi — Tue, 16 Feb 2021 06:55:07 GMT

You could get quite far by creating column which has the "short" labels which you want to create new datatables by and then using subset platform with subset by:

You just need to figure out how to separate "short" labels from your Label column. One way could be possibly with formula like

Left(:Label, Contains(:Label, "_", -1) - 1)

Word(1, :Label, "_")

Re: create new tables from a stack table

txnelson — Tue, 16 Feb 2021 11:47:59 GMT

To do this interactively, go to the area at the top of the Row State column(the column that has the row numbers). Right click and select

Row Selection+>Select Where

Then in the dialog that is opened, specify to find rows where Label Contains "Rpp"

It will then select the rows you want

Now go to

Tables=>Subset

The Subset dialog window will open. Specify to only subset Selected Rows, and all columns

It will then create the new table you want

Repeat the same process for your Wig_350 subset you want.

If you want to do this using JSL, the below will do the same

Names Default To Here( 1 );
dt = Current Data Table();

dt << select where( Contains( :label, "Rpp" ) == 1 );
dt << subset( selected rows( 1 ), selected columns( 0 ) );

dt << select where( Contains( :label, "Wig_350" ) == 1 );