How do I apply filter to a column AND then make just that data go into a New Data Table?Hi all,
This seems straightforward, but is currently causing me troubles.
I have a data set in which one column I'm looking to filter, and instead of manually right clicking the "Selected" rows to do a Data View and generate a new table, I'm wanting to script this action.
How do I perform this in script? I've tried the filter function and it does highlight the correct rows which contain the filtered value, but does not generate a brand new table. I would like all of the original columns to come over in this new table.
Thank you,
Zach
Re: How do I apply filter to a column AND then make just that data go into a New Data Table?Here is a simple piece of code that will create such a subset: The assumption is that dt is pointing to the data table you want to subset
dt2 = dt << subset( selected rows(1), selected columns(0));
Selected Rows(1) will subset only the rows that are currently selected.
Selected Columns(0) will select all columns, not just selected columns.
You should take the time to read the JSL documentation
Help==>Books==>Scripting Guide
Re: How do I apply filter to a column AND then make just that data go into a New Data Table?Thank you!
