Difference between revisions of "Array.filteroncolumn()"

From ZCubes Wiki
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

See Also