744579_en-US

liliconcom

Making Subsets Smarter - Help Needed

Hi Hive Mind,

 

I quite often make a subset of my data table.

 

My current method is

1. Find a value that is representative of my subset
2. Right click -> Select matching cells
3. Tables -> Subset à selected rows, all columns
4. Save file

Alternatively, I will

1. Use “Save as” to create a new file
2. Find a value that is representative of my subset
3. Right click -> Select matching cells
4. Invert selection
5. Delete Rows

 

I do this many times on a weekly basis… and it is painful…

 

So here is my idea that I need help with:

 

I want to create a script that when I have selected my matching cells I can click a button that will make a subset of the selected rows:

 

Here is my best shot so far (it doesn’t work)

 

Dt = current data set();

My_list = dt << Get Selected();

Dt << Subset(

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selected Rows( 0 ),

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selected columns only( 0 )

);

 

Do you have other ideas, or should I do something completely different?

 

Cheers,

Christian

 

Automation and ScriptingData Blending and Cleanup