Make a filtered copy of a worksheet

How to use cDataSet.bigCommit() to create a copy of the values in a sheet, and filter the results

In Make a copy of a worksheet we looked at how to use the .bigCommit() method of  cDataSet  to copy a table from one worksheet to another.  This method is also capable of filtering – meaning only copying rows where a particular column value equals some value. Here’s  how to copy only rows where the city is  London.

Page Content hide
1 VBA
2 Google Apps Script

VBA

Public Sub straightCopyFilter()
    Dim ds As New cDataSet
    ds.populateData(wholeSheet("geoCoding")).bigCommit _
        wholeSheet("messAround"), True, , "city", "London"
End Sub

Google Apps Script

In this example, I am going to assume now that you are using cDataSet from an external library rather than from a local copy. You will see that we are using the functions from the Mcpher namespace. 

function ds() {
  new Mcpher
      .cDataSet() 
      .populateData(Mcpher.wholeSheet("Test"))
      .bigCommit(Mcpher.wholeSheet("messAround"),true,undefined,"city","London");
}

Take a look at One Liners for more tips like this. In the meantime why not join our forum, follow the blog or follow me on twitter to ensure you get updates when they are available.