Basic Examples
- What Is A Collection?
- Create A Collection (manual)
- Create A Collection (from a datasource)
- Create A Single-Column Collection
- Insert A New Row Into A Collection
- Insert Multiple New Rows Into A Collection
- Change The Values In A Row
Selecting Collections Examples
- First Rows Of A Collection
- Last Rows Of A Collection
- Middle Rows Of A Collection
- Get The First Row With A Matching Value (Lookup)
- Get A Value From A Record (LookUp & Positional)
- Get A Column From A Collection
- Filter A Collection
- Filter A Collection With AND Condition
- Filter A Collection With OR Condition
- Ungroup A Table Stored Within A Cell
- Get A Value From A Table Within A Cell
- Get Collection Column Names
Summarizing Collections Examples
- Calculate the SUM, COUNT, AVERAGE, MAX, MIN
- Group By And SUM Values
- Group By And COUNT Values
- Group By And AVERAGE Values
- Group By And MAXIMUM Values
- Group By And MINIMUM Values
- Get The Rows With Top Values
- Get The Rows With Bottom Values
- RANK Rows from Highest To Lowest With Ties
- COUNT The Unique Values In A Column
- Calculate The SUMPRODUCT Of Two Columns
- Add A Column Showing Percentage Of Total
Transforming Collections Examples
- SORT a Collection By One Or More Columns
- JOIN One Column From Another Collection
- JOIN All Columns From Another Collection
- SPLIT A Text Column By Delimiter
- MERGE Two Columns Into A Single Column
- REPLACE A Whole Row In A Collection
- REPLACE All Values In A Column
- REPLACE Cells In A Collection With Blank Values
- ROUND The Values In A Column
- Randomly SHUFFLE The Order Of Rows
- Fill Blanks In A Column With Last Non-Blank Value
- Add A ROW NUMBER Column To A Collection
- RENAME A Column From A Collection
- REMOVE A Row
- REMOVE All Rows
- REMOVE One Or More Columns
- REMOVE All Columns Except
- UNIQUE Values From A Collection Column
- UNIQUE Values From A Collection Column With Blank At The Top
- UNIQUE Records From A Collection
- Matching Values Within 2 Collections
- Change The Date Format In A Collection
- Stack Values From Multiple Columns In A Collection
Exporting Collections Examples
No comments:
Post a Comment