About Functions
Gathr provides a wide variety of functions using which you can directly apply computations on the dataset columns and get desired results.
Lookup Functions
The functions takes columns and/or literals as arguments.
In order to pass column “A” of a dataset “D” as a function argument:
Pass is as for example, @{column.D.A}
There are some exceptions where you need to pass the column name directly.
Following are the functions that take the column name directly.
expr(A)
rename_column(A)
In order to pass a “string literal” as argument to function pass it in double quotes.
For example, “IST”
In order to pass a “number literal” to a function, pass it as it is.
For example, 2 or 1.345
If a dataset named schemaName having a string/date/timestamp column date holding the value 2009-03-01 for a particular row, then
add_months@{column.schemaName.date},2) will return 2009-05-01
Notes: All the examples presented in this topic have column values instead of the entire expression i.e. @{column.schemaName.columnName} add_months@{column.schemaName.date},2) will return 2009-05-01 add_months is a function, @{column.schemaName.date} is an expression and 2009-03-01 is the value of the expression. add_months(@{column.schemaName.date},2) will be shown as: add_months(2009-03-01,2)
A detailed description of the supported functions are explained further.
If you have any feedback on Gathr documentation, please email us!