Difference between revisions of "Array.filteroncolumn()"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
==Array.filteroncolumn(Condition, ExtractColumns, FilterOnColumn)== | ==Array.filteroncolumn(Condition, ExtractColumns, FilterOnColumn)== | ||
*ExtractColumns are the columns that are extracted, and filters are applied on FilterOnColumn where condition is satisfied. | *ExtractColumns are the columns that are extracted, and filters are applied on FilterOnColumn where condition is satisfied. | ||
| − | 1..10.filteroncolumn(">5") | + | *1..10.filteroncolumn(">5") |
{| class="wikitable" | {| class="wikitable" | ||
| + | | 6 | ||
|- | |- | ||
| − | | | + | | 7 |
|- | |- | ||
| − | | | + | | 8 |
|- | |- | ||
| − | | | + | | 9 |
|- | |- | ||
| − | | | + | | 10 |
| − | |- | + | |} |
| − | + | ||
| − | + | *[[1..3,4..6],[2.3..4.3,10.1..12.2],[3/5,10/5]].filteroncolumn(">-10") | |
| + | 0.6 2 | ||
| − | [ | + | *(([51..70,71..90])~).filteroncolumn(">63") |
{| class="wikitable" | {| class="wikitable" | ||
| + | | 64 || 84 | ||
|- | |- | ||
| − | | | + | | 65 || 85 |
|- | |- | ||
| − | | | + | | 66 || 86 |
|- | |- | ||
| − | | | + | | 67 || 87 |
|- | |- | ||
| − | | | + | | 68 || 88 |
|- | |- | ||
| − | | | + | |69 || 89 |
|- | |- | ||
| − | | | + | |70 || 90 |
|} | |} | ||
| − | + | ||
| − | + | ==See Also== | |
| − | + | *[[Array.filteronrow() |filteronrow ]] | |
| − | + | *[[Array.fillwith() | fillwith]] | |
| − | + | *[[Array.aggregate() | aggregate]] | |
| − | |||
Latest revision as of 03:05, 23 February 2022
Array.filteroncolumn(Condition, ExtractColumns, FilterOnColumn)
- ExtractColumns are the columns that are extracted, and filters are applied on FilterOnColumn where condition is satisfied.
- 1..10.filteroncolumn(">5")
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
- [[1..3,4..6],[2.3..4.3,10.1..12.2],[3/5,10/5]].filteroncolumn(">-10")
0.6 2
- (([51..70,71..90])~).filteroncolumn(">63")
| 64 | 84 |
| 65 | 85 |
| 66 | 86 |
| 67 | 87 |
| 68 | 88 |
| 69 | 89 |
| 70 | 90 |