359119_en-US

liliconcom

create new tables from a stack table

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?

 

 

ScriptingRe: create new tables from a stack table

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)

or 

Word(1, :Label, "_")