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