00:00Recently, someone inquired how we can do a filtering of its large data sets using the filter function.
00:05This is how I do it. You're going to have to say filter, open parenthesis.
00:08The first argument will be your data set table itself, comma, followed by the column that you want to display.
00:14So I'm displaying only delivery date and DO here and hit enter.
00:18And once that's done, you can see that your data is presented here.
00:21And one takeaway from this is that on this filter function, when you use this technique here,
00:25you have to make sure that all the columns are accounted for.
00:27I've got eight columns all together here. One, two, three, four, five, six, seven, eight.
00:32All eight of them has been specified.
00:34For some reason, if you miss out one column like this, you can see you get an error.
00:38This method is easy to implement.
00:40However, using this method can become somewhat impractical when dealing with extensive data set containing multiple columns.
00:46For instance, if you have a column on your data set ranging from A to AA.
00:51As you can imagine, this filter function for the second argument is going to be really, really large.
00:57For large data set, this is the formula you're going to have to use.
01:00Like in the other formula, I'm only displaying column B and D.
01:04Now over here, if you hit enter, you can see that it does deliver the same thing.
01:09The beauty of this formula is that you only specify columns that you need.
01:12I need column B and D and it's only specified here.
01:15Now, if you want to display a column G, all you have to do is you have to copy this here on a clipboard like this.
01:21And then just add at the back here plus and then basically change the column from BB to GG like this.
01:29And you have additional column here.
Comments