Applying Column Search Filter
Finally, let’s try applying the column filter. With the same table below, activate SPRITEs search and enter “airport” as a keyword. Then check the “Advanced” checkbox, and check “Filter to relevant columns”, then press the search button. Since “airport” only shows up in the “Source Airport” and “Destination Airport” column, the keys 1 and 2 will map to column 2 and 4. Then you can press Escape to exit search, which will remove the filter and expand the table back to its original state. Just like removing the row filter, the last cell you selected will still map to the same column key, so if you select column 4 before removing the filter, the key 2 will still map to column 4, but the key 1 will map to column 3, and the key 4 map to column 5, and so on. When you are ready, exit SPRITEs and press Next to continue.
Flight Number | Source Airport | Stops | Destination Airport | Carrier | Price |
---|---|---|---|---|---|
1 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Nonstop | John F. Kennedy International Airport (JFK), New York, NY | Delta | $260 |
2 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Nonstop | John F. Kennedy International Airport (JFK), New York, NY | Alaska Airlines | $262 |
3 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Charlotte (CLT) | John F. Kennedy International Airport (JFK), New York, NY | American Airlines | $266 |
4 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Charlotte (CLT) | LaGuardia Airport (LGA), New York, NY | American Airlines | $270 |
5 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Nonstop | Newark Liberty International Airport (EWR), Newark, NJ | United | $258 |
6 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Nonstop | Newark Liberty International Airport (EWR), Newark, NJ | Delta | $256 |
7 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Charlotte (CLT) | Newark Liberty International Airport (EWR), Newark, NJ | American Airlines | $265 |
8 | Seattle-Tacoma International Airport (SEA), Seattle, WA | Chicago (ORD) | Newark Liberty International Airport (EWR), Newark, NJ | American Airlines | $280 |