# Data Transformation

- [Transforms](https://docs.tomat.ai/data-transformation/transforms.md): The concept of a node is central to the data transformation process. Each node represents a specific data transformation action with its associated settings. Nodes are the building blocks of the data
- [Source](https://docs.tomat.ai/data-transformation/transforms/source.md): Adds datasets to the flow
- [New Empty Table](https://docs.tomat.ai/data-transformation/transforms/new-empty-table.md): Adds empty table to the flow, you can manually add and edit data.
- [Output](https://docs.tomat.ai/data-transformation/transforms/output.md): Saves the result of data flow in an outer dataset.
- [Chart](https://docs.tomat.ai/data-transformation/transforms/chart.md): Create a chart.
- [New Column](https://docs.tomat.ai/data-transformation/transforms/new-column.md): Adds a new column with “text”, number, or function
- [If...Then](https://docs.tomat.ai/data-transformation/transforms/if...then.md): Adds a new column with a value based on the specified condition
- [Rolling Functions](https://docs.tomat.ai/data-transformation/transforms/rolling-functions.md): Calculates a window function operates on a group (“window”) of related rows
- [Column Type](https://docs.tomat.ai/data-transformation/transforms/column-type.md): Changes a data type for selected column(s)
- [Columns Edit](https://docs.tomat.ai/data-transformation/transforms/columns-edit.md): Renames, deletes and moves columns
- [Sort](https://docs.tomat.ai/data-transformation/transforms/sort.md): Sorts a table by the specified column(s)
- [Filter](https://docs.tomat.ai/data-transformation/transforms/filter.md): Filters rows based on the specified condition
- [Remove Duplicates](https://docs.tomat.ai/data-transformation/transforms/remove-duplicates.md): Removes duplicated rows
- [Split Text](https://docs.tomat.ai/data-transformation/transforms/split-text.md): Adds a new column with a value based on the specified condition
- [Extract Text](https://docs.tomat.ai/data-transformation/transforms/extract-text.md): Extracts the specified part of text into a new column(s)
- [Find and Replace Text](https://docs.tomat.ai/data-transformation/transforms/find-and-replace-text.md): Finds and replaces the specified part of text
- [Match Text](https://docs.tomat.ai/data-transformation/transforms/match-text.md): Adds a new column with a value based on the specified condition
- [Join](https://docs.tomat.ai/data-transformation/transforms/join.md): Joins 2 tables using the specified columns as keys
- [Union](https://docs.tomat.ai/data-transformation/transforms/union.md): Stacks rows of two or more tables
- [Group By](https://docs.tomat.ai/data-transformation/transforms/group-by.md): Groups rows and calculate aggregation functions
- [Pivot](https://docs.tomat.ai/data-transformation/transforms/pivot.md): Creates new columns from values in the specified columns and computes aggregation functions as values for the new columns
- [Unpivot](https://docs.tomat.ai/data-transformation/transforms/unpivot.md): Reshapes the data by merging one or more columns into key and value columns
- [To JSON](https://docs.tomat.ai/data-transformation/transforms/to-json.md): Creates Objects or Arrays in JSON format from the specified columns
- [From JSON](https://docs.tomat.ai/data-transformation/transforms/from-json.md): Flatten JSON to columns and rows
- [API Call](https://docs.tomat.ai/data-transformation/transforms/api-call.md): Calls an external API and return a new column with answers
- [Use AI](https://docs.tomat.ai/data-transformation/transforms/use-ai.md): Calls AI for each row to extract, enrich or cleanup.
- [AI Table](https://docs.tomat.ai/data-transformation/transforms/ai-table.md): Creates a new table based on GPT prompt
- [Formulas](https://docs.tomat.ai/data-transformation/formulas.md)
- [What are Formulas?](https://docs.tomat.ai/data-transformation/formulas/what-are-formulas.md)
- [Math Functions](https://docs.tomat.ai/data-transformation/formulas/math-functions.md)
- [Abs](https://docs.tomat.ai/data-transformation/formulas/math-functions/abs.md)
- [Ceiling](https://docs.tomat.ai/data-transformation/formulas/math-functions/ceiling.md)
- [Exp](https://docs.tomat.ai/data-transformation/formulas/math-functions/exp.md)
- [Floor](https://docs.tomat.ai/data-transformation/formulas/math-functions/floor.md)
- [IsEven](https://docs.tomat.ai/data-transformation/formulas/math-functions/iseven.md)
- [IsOdd](https://docs.tomat.ai/data-transformation/formulas/math-functions/isodd.md)
- [Ln](https://docs.tomat.ai/data-transformation/formulas/math-functions/ln.md)
- [Log](https://docs.tomat.ai/data-transformation/formulas/math-functions/log.md)
- [Log10](https://docs.tomat.ai/data-transformation/formulas/math-functions/log10.md)
- [Mod](https://docs.tomat.ai/data-transformation/formulas/math-functions/mod.md)
- [Pi](https://docs.tomat.ai/data-transformation/formulas/math-functions/pi.md)
- [Power](https://docs.tomat.ai/data-transformation/formulas/math-functions/power.md)
- [Quotient](https://docs.tomat.ai/data-transformation/formulas/math-functions/quotient.md)
- [Round](https://docs.tomat.ai/data-transformation/formulas/math-functions/round.md)
- [RoundDown](https://docs.tomat.ai/data-transformation/formulas/math-functions/rounddown.md)
- [RoundUp](https://docs.tomat.ai/data-transformation/formulas/math-functions/roundup.md)
- [Sign](https://docs.tomat.ai/data-transformation/formulas/math-functions/sign.md)
- [Sqrt](https://docs.tomat.ai/data-transformation/formulas/math-functions/sqrt.md)
- [Truncate](https://docs.tomat.ai/data-transformation/formulas/math-functions/truncate.md)
- [Trigonometric Functions](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions.md)
- [Acos](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/acos.md)
- [Asin](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/asin.md)
- [Atan](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/atan.md)
- [Atan2](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/atan2.md)
- [Cos](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/cos.md)
- [Cot](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/cot.md)
- [Degrees](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/degrees.md)
- [Radians](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/radians.md)
- [Sin](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/sin.md)
- [Tan](https://docs.tomat.ai/data-transformation/formulas/trigonometric-functions/tan.md)
- [String Functions](https://docs.tomat.ai/data-transformation/formulas/string-functions.md)
- [Compare](https://docs.tomat.ai/data-transformation/formulas/string-functions/compare.md)
- [Concat](https://docs.tomat.ai/data-transformation/formulas/string-functions/concat.md)
- [Contains](https://docs.tomat.ai/data-transformation/formulas/string-functions/contains.md)
- [In](https://docs.tomat.ai/data-transformation/formulas/string-functions/in.md)
- [CountMatches](https://docs.tomat.ai/data-transformation/formulas/string-functions/countmatches.md)
- [CountMatchesRegexp](https://docs.tomat.ai/data-transformation/formulas/string-functions/countmatchesregexp.md): Regexp
- [EndsWith](https://docs.tomat.ai/data-transformation/formulas/string-functions/endswith.md)
- [EndsWithRegexp](https://docs.tomat.ai/data-transformation/formulas/string-functions/endswithregexp.md)
- [Extract](https://docs.tomat.ai/data-transformation/formulas/string-functions/extract.md)
- [FindMatchOfString](https://docs.tomat.ai/data-transformation/formulas/string-functions/findmatchofstring.md)
- [FindMatchOfRegexp](https://docs.tomat.ai/data-transformation/formulas/string-functions/findmatchofregexp.md)
- [FindMatchesOfString](https://docs.tomat.ai/data-transformation/formulas/string-functions/findmatchesofstring.md)
- [FindMatchesOfRegexp](https://docs.tomat.ai/data-transformation/formulas/string-functions/findmatchesofregexp.md)
- [Left](https://docs.tomat.ai/data-transformation/formulas/string-functions/left.md)
- [Length](https://docs.tomat.ai/data-transformation/formulas/string-functions/length.md)
- [Lower](https://docs.tomat.ai/data-transformation/formulas/string-functions/lower.md)
- [Matches](https://docs.tomat.ai/data-transformation/formulas/string-functions/matches.md)
- [Pad](https://docs.tomat.ai/data-transformation/formulas/string-functions/pad.md)
- [ProperCase](https://docs.tomat.ai/data-transformation/formulas/string-functions/propercase.md)
- [RemoveSymbols](https://docs.tomat.ai/data-transformation/formulas/string-functions/removesymbols.md)
- [RemoveWhitespaces](https://docs.tomat.ai/data-transformation/formulas/string-functions/removewhitespaces.md)
- [Repeat](https://docs.tomat.ai/data-transformation/formulas/string-functions/repeat.md)
- [Replace](https://docs.tomat.ai/data-transformation/formulas/string-functions/replace.md)
- [ReplaceRegexp](https://docs.tomat.ai/data-transformation/formulas/string-functions/replaceregexp.md)
- [Reverse](https://docs.tomat.ai/data-transformation/formulas/string-functions/reverse.md)
- [Right](https://docs.tomat.ai/data-transformation/formulas/string-functions/right.md)
- [Spaces](https://docs.tomat.ai/data-transformation/formulas/string-functions/spaces.md)
- [Split](https://docs.tomat.ai/data-transformation/formulas/string-functions/split.md)
- [SplitRegexp](https://docs.tomat.ai/data-transformation/formulas/string-functions/splitregexp.md)
- [StartsWith](https://docs.tomat.ai/data-transformation/formulas/string-functions/startswith.md)
- [StartsWithRegexp](https://docs.tomat.ai/data-transformation/formulas/string-functions/startswithregexp.md)
- [Stuff](https://docs.tomat.ai/data-transformation/formulas/string-functions/stuff.md)
- [Substring](https://docs.tomat.ai/data-transformation/formulas/string-functions/substring.md)
- [SubstringDelimiter](https://docs.tomat.ai/data-transformation/formulas/string-functions/substringdelimiter.md)
- [SubstringRegexpDelimiter](https://docs.tomat.ai/data-transformation/formulas/string-functions/substringregexpdelimiter.md)
- [Trim](https://docs.tomat.ai/data-transformation/formulas/string-functions/trim.md)
- [Upper](https://docs.tomat.ai/data-transformation/formulas/string-functions/upper.md)
- [Date & Time Functions](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions.md)
- [Date](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/date.md)
- [DateAdd](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/dateadd.md)
- [DateAdd](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/dateadd-1.md)
- [DateDiff](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/datediff.md)
- [DateDiff2](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/datediff2.md)
- [DateFromParts](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/datefromparts.md)
- [DateTime](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/datetime.md)
- [DateTimeFromParts](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/datetimefromparts.md)
- [DateTrunc](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/datetrunc.md)
- [DayName](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/dayname.md)
- [DayOfMonth](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/dayofmonth.md)
- [DayOfWeek](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/dayofweek.md)
- [DayOfYear](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/dayofyear.md)
- [Hour](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/hour.md)
- [Minute](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/minute.md)
- [Month](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/month.md)
- [MonthName](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/monthname.md)
- [Now](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/now.md)
- [Quarter](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/quarter.md)
- [Second](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/second.md)
- [Time](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/time.md)
- [TimeFromParts](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/timefromparts.md)
- [Today](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/today.md)
- [Week](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/week.md)
- [Year](https://docs.tomat.ai/data-transformation/formulas/date-and-time-functions/year.md)
- [Aggregate Functions](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions.md)
- [Array](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/array.md)
- [ArrayIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/arrayif.md)
- [Avg](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/avg.md)
- [AvgIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/avgif.md)
- [Count](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/count.md)
- [CountA](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/counta.md)
- [CountIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/countif.md)
- [CountUnique](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/countunique.md)
- [Max](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/max.md)
- [MaxIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/maxif.md)
- [Median](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/median.md)
- [MedianIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/medianif.md)
- [Min](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/min.md)
- [MinIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/minif.md)
- [Mode](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/mode.md)
- [ModeIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/modeif.md)
- [Percentile](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/percentile.md)
- [Quartile](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/quartile.md)
- [StdDev](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/stddev.md)
- [StdDevIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/stddevif.md)
- [Sum](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/sum.md)
- [SumIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/sumif.md)
- [SumProduct](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/sumproduct.md)
- [Variance](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/variance.md)
- [VarianceIf](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/varianceif.md)
- [Conversion Functions](https://docs.tomat.ai/data-transformation/formulas/conversion-functions.md)
- [ToArray](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/toarray.md)
- [ToBoolean](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/toboolean.md)
- [ToDate](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/todate.md)
- [ToDateTime](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/todatetime.md)
- [ToDecimal](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/todecimal.md)
- [ToInteger](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/tointeger.md)
- [ToObject](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/toobject.md)
- [ToTime](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/totime.md)
- [ToString](https://docs.tomat.ai/data-transformation/formulas/conversion-functions/tostring.md)
- [Misc Functions](https://docs.tomat.ai/data-transformation/formulas/misc-functions.md)
- [At](https://docs.tomat.ai/data-transformation/formulas/misc-functions/at.md)
- [IsMissing](https://docs.tomat.ai/data-transformation/formulas/misc-functions/ismissing.md)
- [RowNumber](https://docs.tomat.ai/data-transformation/formulas/misc-functions/rownumber.md)
- [Random](https://docs.tomat.ai/data-transformation/formulas/misc-functions/random.md)
- [If](https://docs.tomat.ai/data-transformation/formulas/misc-functions/if.md)
- [Coalesce](https://docs.tomat.ai/data-transformation/formulas/misc-functions/coalesce.md)
- [True](https://docs.tomat.ai/data-transformation/formulas/misc-functions/true.md)
- [False](https://docs.tomat.ai/data-transformation/formulas/misc-functions/false.md)
- [Null](https://docs.tomat.ai/data-transformation/formulas/misc-functions/null.md)
- [$target](https://docs.tomat.ai/data-transformation/formulas/misc-functions/usdtarget.md)
- [Window Functions](https://docs.tomat.ai/data-transformation/formulas/window-functions.md)
- [Custom Functions](https://docs.tomat.ai/data-transformation/formulas/custom-functions.md)
- [Data Types](https://docs.tomat.ai/data-transformation/formulas/data-types.md): Supported data types and conversion variants between them
- [Supported Date Parts](https://docs.tomat.ai/data-transformation/formulas/supported-date-parts.md)
- [Regex: List of Tokes](https://docs.tomat.ai/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.tomat.ai/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.