# Data Transformation

- [Formulas](https://docs.tabula.io/data-transformation/formulas.md)
- [What are Formulas?](https://docs.tabula.io/data-transformation/formulas/what-are-formulas.md)
- [Math Functions](https://docs.tabula.io/data-transformation/formulas/math-functions.md)
- [Abs](https://docs.tabula.io/data-transformation/formulas/math-functions/abs.md)
- [Ceiling](https://docs.tabula.io/data-transformation/formulas/math-functions/ceiling.md)
- [Exp](https://docs.tabula.io/data-transformation/formulas/math-functions/exp.md)
- [Floor](https://docs.tabula.io/data-transformation/formulas/math-functions/floor.md)
- [IsEven](https://docs.tabula.io/data-transformation/formulas/math-functions/iseven.md)
- [IsOdd](https://docs.tabula.io/data-transformation/formulas/math-functions/isodd.md)
- [Ln](https://docs.tabula.io/data-transformation/formulas/math-functions/ln.md)
- [Log](https://docs.tabula.io/data-transformation/formulas/math-functions/log.md)
- [Log10](https://docs.tabula.io/data-transformation/formulas/math-functions/log10.md)
- [Mod](https://docs.tabula.io/data-transformation/formulas/math-functions/mod.md)
- [Pi](https://docs.tabula.io/data-transformation/formulas/math-functions/pi.md)
- [Power](https://docs.tabula.io/data-transformation/formulas/math-functions/power.md)
- [Quotient](https://docs.tabula.io/data-transformation/formulas/math-functions/quotient.md)
- [Round](https://docs.tabula.io/data-transformation/formulas/math-functions/round.md)
- [RoundDown](https://docs.tabula.io/data-transformation/formulas/math-functions/rounddown.md)
- [RoundUp](https://docs.tabula.io/data-transformation/formulas/math-functions/roundup.md)
- [Sign](https://docs.tabula.io/data-transformation/formulas/math-functions/sign.md)
- [Sqrt](https://docs.tabula.io/data-transformation/formulas/math-functions/sqrt.md)
- [Truncate](https://docs.tabula.io/data-transformation/formulas/math-functions/truncate.md)
- [Trigonometric Functions](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions.md)
- [Acos](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/acos.md)
- [Asin](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/asin.md)
- [Atan](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/atan.md)
- [Atan2](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/atan2.md)
- [Cos](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/cos.md)
- [Cot](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/cot.md)
- [Degrees](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/degrees.md)
- [Radians](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/radians.md)
- [Sin](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/sin.md)
- [Tan](https://docs.tabula.io/data-transformation/formulas/trigonometric-functions/tan.md)
- [String Functions](https://docs.tabula.io/data-transformation/formulas/string-functions.md)
- [Compare](https://docs.tabula.io/data-transformation/formulas/string-functions/compare.md)
- [Concat](https://docs.tabula.io/data-transformation/formulas/string-functions/concat.md)
- [Contains](https://docs.tabula.io/data-transformation/formulas/string-functions/contains.md)
- [In](https://docs.tabula.io/data-transformation/formulas/string-functions/in.md)
- [CountMatches](https://docs.tabula.io/data-transformation/formulas/string-functions/countmatches.md)
- [CountMatchesRegexp](https://docs.tabula.io/data-transformation/formulas/string-functions/countmatchesregexp.md): Regexp
- [EndsWith](https://docs.tabula.io/data-transformation/formulas/string-functions/endswith.md)
- [EndsWithRegexp](https://docs.tabula.io/data-transformation/formulas/string-functions/endswithregexp.md)
- [Extract](https://docs.tabula.io/data-transformation/formulas/string-functions/extract.md)
- [FindMatchOfString](https://docs.tabula.io/data-transformation/formulas/string-functions/findmatchofstring.md)
- [FindMatchOfRegexp](https://docs.tabula.io/data-transformation/formulas/string-functions/findmatchofregexp.md)
- [FindMatchesOfString](https://docs.tabula.io/data-transformation/formulas/string-functions/findmatchesofstring.md)
- [FindMatchesOfRegexp](https://docs.tabula.io/data-transformation/formulas/string-functions/findmatchesofregexp.md)
- [Left](https://docs.tabula.io/data-transformation/formulas/string-functions/left.md)
- [Length](https://docs.tabula.io/data-transformation/formulas/string-functions/length.md)
- [Lower](https://docs.tabula.io/data-transformation/formulas/string-functions/lower.md)
- [Matches](https://docs.tabula.io/data-transformation/formulas/string-functions/matches.md)
- [Pad](https://docs.tabula.io/data-transformation/formulas/string-functions/pad.md)
- [ProperCase](https://docs.tabula.io/data-transformation/formulas/string-functions/propercase.md)
- [RemoveSymbols](https://docs.tabula.io/data-transformation/formulas/string-functions/removesymbols.md)
- [RemoveWhitespaces](https://docs.tabula.io/data-transformation/formulas/string-functions/removewhitespaces.md)
- [Repeat](https://docs.tabula.io/data-transformation/formulas/string-functions/repeat.md)
- [Replace](https://docs.tabula.io/data-transformation/formulas/string-functions/replace.md)
- [ReplaceRegexp](https://docs.tabula.io/data-transformation/formulas/string-functions/replaceregexp.md)
- [Reverse](https://docs.tabula.io/data-transformation/formulas/string-functions/reverse.md)
- [Right](https://docs.tabula.io/data-transformation/formulas/string-functions/right.md)
- [Spaces](https://docs.tabula.io/data-transformation/formulas/string-functions/spaces.md)
- [Split](https://docs.tabula.io/data-transformation/formulas/string-functions/split.md)
- [SplitRegexp](https://docs.tabula.io/data-transformation/formulas/string-functions/splitregexp.md)
- [StartsWith](https://docs.tabula.io/data-transformation/formulas/string-functions/startswith.md)
- [StartsWithRegexp](https://docs.tabula.io/data-transformation/formulas/string-functions/startswithregexp.md)
- [Stuff](https://docs.tabula.io/data-transformation/formulas/string-functions/stuff.md)
- [Substring](https://docs.tabula.io/data-transformation/formulas/string-functions/substring.md)
- [SubstringDelimiter](https://docs.tabula.io/data-transformation/formulas/string-functions/substringdelimiter.md)
- [SubstringRegexpDelimiter](https://docs.tabula.io/data-transformation/formulas/string-functions/substringregexpdelimiter.md)
- [Trim](https://docs.tabula.io/data-transformation/formulas/string-functions/trim.md)
- [Upper](https://docs.tabula.io/data-transformation/formulas/string-functions/upper.md)
- [Date & Time Functions](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions.md)
- [Date](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/date.md)
- [DateAdd](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/dateadd.md)
- [DateAdd2](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/dateadd2.md)
- [DateDiff](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/datediff.md)
- [DateDiff2](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/datediff2.md)
- [DateFromParts](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/datefromparts.md)
- [DateTime](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/datetime.md)
- [DateTimeFromParts](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/datetimefromparts.md)
- [DateTrunc](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/datetrunc.md)
- [DayName](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/dayname.md)
- [DayOfMonth](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/dayofmonth.md)
- [DayOfWeek](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/dayofweek.md)
- [DayOfYear](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/dayofyear.md)
- [Hour](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/hour.md)
- [Minute](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/minute.md)
- [Month](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/month.md)
- [MonthName](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/monthname.md)
- [Now](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/now.md)
- [Quarter](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/quarter.md)
- [Second](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/second.md)
- [Time](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/time.md)
- [TimeFromParts](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/timefromparts.md)
- [Today](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/today.md)
- [Week](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/week.md)
- [Year](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/year.md)
- [Aggregate Functions](https://docs.tabula.io/data-transformation/formulas/aggregate-functions.md)
- [Any](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/any.md)
- [AnyIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/anyif.md)
- [Array](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/array.md)
- [ArrayIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/arrayif.md)
- [Avg](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/avg.md)
- [AvgIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/avgif.md)
- [AvgInRow](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/avginrow.md)
- [Count](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/count.md)
- [CountA](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/counta.md)
- [CountIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/countif.md)
- [CountUnique](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/countunique.md)
- [Max](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/max.md)
- [MaxIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/maxif.md)
- [MaxInRow](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/maxinrow.md)
- [Median](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/median.md)
- [MedianIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/medianif.md)
- [Min](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/min.md)
- [MinIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/minif.md)
- [MinInRow](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/mininrow.md)
- [Mode](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/mode.md)
- [ModeIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/modeif.md)
- [Percentile](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/percentile.md)
- [Quartile](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/quartile.md)
- [StdDev](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/stddev.md)
- [StdDevIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/stddevif.md)
- [Sum](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/sum.md)
- [SumIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/sumif.md)
- [SumProduct](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/sumproduct.md)
- [Variance](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/variance.md)
- [VarianceIf](https://docs.tabula.io/data-transformation/formulas/aggregate-functions/varianceif.md)
- [Conversion Functions](https://docs.tabula.io/data-transformation/formulas/conversion-functions.md)
- [ToArray](https://docs.tabula.io/data-transformation/formulas/conversion-functions/toarray.md)
- [ArrayToString](https://docs.tabula.io/data-transformation/formulas/conversion-functions/arraytostring.md)
- [ToBoolean](https://docs.tabula.io/data-transformation/formulas/conversion-functions/toboolean.md)
- [ToDate](https://docs.tabula.io/data-transformation/formulas/conversion-functions/todate.md)
- [ToDateTime](https://docs.tabula.io/data-transformation/formulas/conversion-functions/todatetime.md)
- [ToDecimal](https://docs.tabula.io/data-transformation/formulas/conversion-functions/todecimal.md)
- [ToInteger](https://docs.tabula.io/data-transformation/formulas/conversion-functions/tointeger.md)
- [ToObject](https://docs.tabula.io/data-transformation/formulas/conversion-functions/toobject.md)
- [ToTime](https://docs.tabula.io/data-transformation/formulas/conversion-functions/totime.md)
- [ToString](https://docs.tabula.io/data-transformation/formulas/conversion-functions/tostring.md)
- [Misc Functions](https://docs.tabula.io/data-transformation/formulas/misc-functions.md)
- [At](https://docs.tabula.io/data-transformation/formulas/misc-functions/at.md)
- [IsMissing](https://docs.tabula.io/data-transformation/formulas/misc-functions/ismissing.md)
- [RowNumber](https://docs.tabula.io/data-transformation/formulas/misc-functions/rownumber.md)
- [Random](https://docs.tabula.io/data-transformation/formulas/misc-functions/random.md)
- [If](https://docs.tabula.io/data-transformation/formulas/misc-functions/if.md)
- [Coalesce](https://docs.tabula.io/data-transformation/formulas/misc-functions/coalesce.md)
- [True](https://docs.tabula.io/data-transformation/formulas/misc-functions/true.md)
- [False](https://docs.tabula.io/data-transformation/formulas/misc-functions/false.md)
- [Null](https://docs.tabula.io/data-transformation/formulas/misc-functions/null.md)
- [$target](https://docs.tabula.io/data-transformation/formulas/misc-functions/usdtarget.md)
- [Window Functions](https://docs.tabula.io/data-transformation/formulas/window-functions.md)
- [Custom Functions](https://docs.tabula.io/data-transformation/formulas/custom-functions.md)
- [Data Types](https://docs.tabula.io/data-transformation/formulas/data-types.md): Supported data types and conversion variants between them
- [Supported Date Parts](https://docs.tabula.io/data-transformation/formulas/supported-date-parts.md)
- [Regex: List of Tokes](https://docs.tabula.io/data-transformation/formulas/regex-list-of-tokes.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tabula.io/data-transformation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.