Difference between revisions of "Array.filteroncolumn()"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
*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") | ||
| − | 6 | + | {| class="wikitable" |
| − | + | |- | |
| − | + | |6 | |
| − | + | |- | |
| − | + | |7 | |
| + | |- | ||
| + | |8 | ||
| + | |- | ||
| + | |9 | ||
| + | |- | ||
| + | |10 | ||
| + | } | ||
| + | |||
| + | [1..10,11..20].filteronrow(">4") | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | | 5 || 15 | ||
| + | |- | ||
| + | | 6 || 16 | ||
| + | |- | ||
| + | | 7 || 17 | ||
| + | |- | ||
| + | |8 ||18 | ||
| + | |- | ||
| + | |9 || 19 | ||
| + | |- | ||
| + | |10 ||20 | ||
| + | |} | ||
| + | 5 15 | ||
| + | 6 16 | ||
| + | 7 17 | ||
| + | 8 18 | ||
| + | 9 19 | ||
| + | 10 20 | ||
Revision as of 05:48, 1 April 2020
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..10,11..20].filteronrow(">4")
5 15 6 16 7 17 8 18 9 19 10 20 |