Skip to main content

Appendix

Data Types

Mammoth supports the following data types for columns:

  1. Text: The data can contain text values of any length.
  2. Number: The data can contain integers or decimal values.
  3. Date: The data can contain dates with or without time.
note
  • This is similar to how many SQL databases operate. Typed systems are more reliable than un-typed systems like Excel.
  • Mammoth is not a spreadsheet program. Hence two cells in the same column cannot contain mixed types.
  • Mammoth can auto detect types in most cases. If you are not happy with the type a column has, it might mean your original data was not clean. You can always use a Convert Column task to convert the data into the right type. This might result in loss of those values that are not matching the type you want to change the column to. It might be helpful to use Explore Cards to discover the data properly before attempting a type conversion.

Date Patterns and Templates

Mammoth supports the following date patterns and templates:

PatternDescription
HHHour of day (01-12)
HH12Hour of day (01-12)
HH24Hour of day (00-23)
MIMinute (00-59)
SSSecond (00-59)
AM, am, PM or pmMeridiem indicator (without periods)
A.M., a.m., P.M. or p.m.Meridiem indicator (with periods)
Y,YYYYear (4 or more digits) with comma
YYYYYear (4 or more digits)
YYYLast 3 digits of year
YYLast 2 digits of year
YLast digit of year
BC, bc, AD or adEra indicator (without periods)
> B.C., b.c., A.D. or a.d.Era indicator (with periods)
MONTHUpper case month name
MonthCapitalized month name
monthLower case month name
MONAbbreviated upper case month name
MonAbbreviated capitalized month name
monAbbreviated lower case month name
MMMonth number (01-12)
DAYUpper case day name
DayCapitalized day name
dayLower case day name
DYAbbreviated upper case day name
DyAbbreviated capitalized day name
dyAbbreviated lower case day name
DDDay of month (01-31)
TZUpper case time-zone abbreviation
OFTime-zone offset from UTC
T, ZLetters T, Z
UNIX TIMESTAMPTreat as unix timestamp

Empty/Blank Values

Empty values occur when:

  1. The original data contains empty cells. These are also called NULL depending on the platform is data is coming from.
  2. A new column has been added through a New Column task.

Formatting Data

Mammoth allows formatting data for visual convenience without actually affecting the underlying data.

Number Formatting

The following options exist when formatting a number.

  1. Number of decimal places.
  2. Toggle comma separation.
  3. Currency Symbol. This option is mutually exclusive with Show as Percentage.
  4. Show as Percentage. This option is mutually exclusive with Show as Currency Symbol.

This option can be reached through

  1. The column menu for numeric columns.
  2. Task panel for tasks where this is applicable.
  3. Add/Edit Metric Menu.

Note that this formatting is just cosmetic. Data is not affected when this is done. For example 3.3333 can be formatted to look like 3. But when you apply a task such as filter, this will not be taken into consideration.

Date Formatting

A list of popular date formats will be listed in this menu. Note that this formatting is just cosmetic. Data is not affected when this is done. For example "2012-12-28 12:39:00" can be formatted to look like "28 December, 2012". But when you apply a task such as filter, the time part of the data will still be taken into account.

Numeric functions

Here is a list of numeric functions supported by Mammoth. In other words, these functions produce numbers as their output.

FunctionDescription
COUNTThis function returns the row count.
SUMThis function returns the sum of a given column. This can be be used on numeric columns.
AVGThis function returns the average of a given column. This can be be used on numeric columns.
MINThis function returns the minimum value of a given column. This can be be used on numeric numeric.
MAXThis function returns the maximum value of a given column. This can be be used on numeric columns.
STTDDEVThis function returns the standard deviation of the values of a given column. This can be be used on numeric columns.
VARIANCEThis function returns the variance of the values of a given column. This can be be used on numeric columns.
INTThis function returns the integer part of the input given to it.
For example INT(3.1) = 3, INT(3.9) = 3 This function is supported only in the Math Task. It can be applied on any ArithMetric Expression.

Result Column

Some of the column tasks in Mammoth produce the results into a column. These two choices are provided wherever it makes sense.

  1. New column: The result of the task goes into a new column.
  2. Existing column: The result of the task goes into an existing column.

New Column

If this option is chosen, the following sub options must be given.

  • New column name: Must be a unique name for the column in the view.

  • Type: This is used to set the type of the data. This option is not always provided where the type is obvious.

Existing column

If this option is chosen, the following sub option will be provided.

  • Target column: The column into which the result should go into. This list contains only the columns whose data-type matches the expectations from those task.

Sort in tasks

Both Show Top and Bottom rule and Window Function depend on the sort to determine the correct result. If no sort is provided, a default sort is assumed which is the order of the data in the view. This is the same as order in which you see data in the grid if there is no sort has been applied on the data view.

If you perform operations like filter and join, the data might not be in the same order as dataset. Hence it is recommended to set a sort explicitly on these tasks to prevent any undesirable outcomes.

The sort menu will appear as a sub-menu in these tasks' menus. You can specify one or more columns to sort by. The additional columns will be used to break the tie if the first column being used sort by is not able to resolve the order of any two rows.

A column can be sorted either in the ascending order or the descending order.