Subscribe Bookmark RSS Feed
txnelson

Super User

Joined:

Jun 22, 2012

Set Column Value for Selected Rows Using a Data Filter Documentation

This addin allows the user to use a data filter to make simple or complex row selections, and then specify the column to write to and the value to write to the selected rows.  While this is no different than selecting rows with a data filter, and then pasting a value into one of the selected cell, which will replicate the action to all selected rows, the addin is a more friendly method, allowing the user to select the column to be changed, and to type into an input field, the value to be written to the selected rows.

This is a great way to create a binning column for bins determined by a complex combination of columns

Here is an example using the Big Class data table:

10810_pastedImage_0.png

Just specify the column to be changed....in this case a new column called "Bin" was been added to the data table.  And then use the Data Filter to do the selection.  Finally specify the value to be written to the column "Bin" for the selected rows.

10813_pastedImage_0.png

Once the "Set Value" button is clicked on, the values are written to the data table

10812_pastedImage_2.png

Article Labels
Article Tags
Contributors