> ## Documentation Index
> Fetch the complete documentation index at: https://axiom-keh-dashboards-v2-docs.mintlify.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Llms apl

# Axiom Docs

## Query reference

* [arg\_max](https://axiom.co/docs/apl/aggregation-function/arg-max.md): This page explains how to use the arg\_max aggregation in APL.
* [arg\_min](https://axiom.co/docs/apl/aggregation-function/arg-min.md): This page explains how to use the arg\_min aggregation in APL.
* [avg](https://axiom.co/docs/apl/aggregation-function/avg.md): This page explains how to use the avg aggregation function in APL.
* [avgif](https://axiom.co/docs/apl/aggregation-function/avgif.md): This page explains how to use the avgif aggregation function in APL.
* [count](https://axiom.co/docs/apl/aggregation-function/count.md): This page explains how to use the count aggregation function in APL.
* [countif](https://axiom.co/docs/apl/aggregation-function/countif.md): This page explains how to use the countif aggregation function in APL.
* [dcount](https://axiom.co/docs/apl/aggregation-function/dcount.md): This page explains how to use the dcount aggregation function in APL.
* [dcountif](https://axiom.co/docs/apl/aggregation-function/dcountif.md): This page explains how to use the dcountif aggregation function in APL.
* [histogram](https://axiom.co/docs/apl/aggregation-function/histogram.md): This page explains how to use the histogram aggregation function in APL.
* [histogramif](https://axiom.co/docs/apl/aggregation-function/histogramif.md): This page explains how to use the histogramif aggregation function in APL.
* [make\_list](https://axiom.co/docs/apl/aggregation-function/make-list.md): This page explains how to use the make\_list aggregation function in APL.
* [make\_list\_if](https://axiom.co/docs/apl/aggregation-function/make-list-if.md): This page explains how to use the make\_list\_if aggregation function in APL.
* [make\_set](https://axiom.co/docs/apl/aggregation-function/make-set.md): This page explains how to use the make\_set aggregation function in APL.
* [make\_set\_if](https://axiom.co/docs/apl/aggregation-function/make-set-if.md): This page explains how to use the make\_set\_if aggregation function in APL.
* [max](https://axiom.co/docs/apl/aggregation-function/max.md): This page explains how to use the max aggregation function in APL.
* [maxif](https://axiom.co/docs/apl/aggregation-function/maxif.md): This page explains how to use the maxif aggregation function in APL.
* [min](https://axiom.co/docs/apl/aggregation-function/min.md): This page explains how to use the min aggregation function in APL.
* [minif](https://axiom.co/docs/apl/aggregation-function/minif.md): This page explains how to use the minif aggregation function in APL.
* [percentile](https://axiom.co/docs/apl/aggregation-function/percentile.md): This page explains how to use the percentile aggregation function in APL.
* [percentileif](https://axiom.co/docs/apl/aggregation-function/percentileif.md): This page explains how to use the percentileif aggregation function in APL.
* [percentiles\_array](https://axiom.co/docs/apl/aggregation-function/percentiles-array.md): This page explains how to use the percentiles\_array function in APL.
* [percentiles\_arrayif](https://axiom.co/docs/apl/aggregation-function/percentiles-arrayif.md): This page explains how to use the percentiles\_array function in APL.
* [rate](https://axiom.co/docs/apl/aggregation-function/rate.md): This page explains how to use the rate aggregation function in APL.
* [spotlight](https://axiom.co/docs/apl/aggregation-function/spotlight.md): This page explains how to use the spotlight function in APL to compare a selected set of events against a baseline and surface the most significant differences.
* [Aggregation functions](https://axiom.co/docs/apl/aggregation-function/statistical-functions.md): This section explains how to use and combine different aggregation functions in APL.
* [stdev](https://axiom.co/docs/apl/aggregation-function/stdev.md): This page explains how to use the stdev aggregation function in APL.
* [stdevif](https://axiom.co/docs/apl/aggregation-function/stdevif.md): This page explains how to use the stdevif aggregation function in APL.
* [sum](https://axiom.co/docs/apl/aggregation-function/sum.md): This page explains how to use the sum aggregation function in APL.
* [sumif](https://axiom.co/docs/apl/aggregation-function/sumif.md): This page explains how to use the sumif aggregation function in APL.
* [topk](https://axiom.co/docs/apl/aggregation-function/topk.md): This page explains how to use the topk aggregation function in APL.
* [topkif](https://axiom.co/docs/apl/aggregation-function/topkif.md): This page explains how to use the topkif aggregation in APL.
* [variance](https://axiom.co/docs/apl/aggregation-function/variance.md): This page explains how to use the variance aggregation function in APL.
* [varianceif](https://axiom.co/docs/apl/aggregation-function/varianceif.md): This page explains how to use the varianceif aggregation function in APL.
* [All features of Axiom Processing Language (APL)](https://axiom.co/docs/apl/apl-features.md): This page gives an overview about all the features of Axiom Processing Language (APL).
* [Map fields](https://axiom.co/docs/apl/data-types/map-fields.md): This page explains what map fields are and how to query them.
* [Null values](https://axiom.co/docs/apl/data-types/null-values.md): This page explains how APL represents missing values.
* [Scalar data types](https://axiom.co/docs/apl/data-types/scalar-data-types.md): This page explains the data types in APL.
* [Entity names](https://axiom.co/docs/apl/entities/entity-names.md): This page explains how to use entity names in your APL query.
* [Migrate from SQL to APL](https://axiom.co/docs/apl/guides/migrating-from-sql-to-apl.md): This guide helps you migrate SQL to APL, helping you understand key differences and providing you with query examples.
* [Migrate from Sumo Logic Query Language to APL](https://axiom.co/docs/apl/guides/migrating-from-sumologic-to-apl.md): This guide dives into why APL could be a superior choice for your data needs, and the differences between Sumo Logic and APL.
* [Migrate from Splunk SPL to APL](https://axiom.co/docs/apl/guides/splunk-cheat-sheet.md): This step-by-step guide provides a high-level mapping from Splunk SPL to APL.
* [Axiom Processing Language (APL)](https://axiom.co/docs/apl/introduction.md): This section explains how to use the Axiom Processing Language to get deeper insights from your data.
* [Set statement](https://axiom.co/docs/apl/query-statement/set-statement.md): The set statement is used to set a query option in your APL query.
* [Special field attributes](https://axiom.co/docs/apl/reference/special-field-attributes.md): This page explains how to implement special fields within APL queries to enhance the functionality and interactivity of datasets. Use these fields in APL queries to add unique behaviors to the Axiom user interface.
* [Array functions](https://axiom.co/docs/apl/scalar-functions/array-functions.md): This section explains how to use array functions in APL.
* [array\_concat](https://axiom.co/docs/apl/scalar-functions/array-functions/array-concat.md): This page explains how to use the array\_concat function in APL.
* [array\_extract](https://axiom.co/docs/apl/scalar-functions/array-functions/array-extract.md): This page explains how to use the array\_extract function in APL.
* [array\_iff](https://axiom.co/docs/apl/scalar-functions/array-functions/array-iff.md): This page explains how to use the array\_iff function in APL.
* [array\_index\_of](https://axiom.co/docs/apl/scalar-functions/array-functions/array-index-of.md): This page explains how to use the array\_index\_of function in APL.
* [array\_length](https://axiom.co/docs/apl/scalar-functions/array-functions/array-length.md): This page explains how to use the array\_length function in APL.
* [array\_reverse](https://axiom.co/docs/apl/scalar-functions/array-functions/array-reverse.md): This page explains how to use the array\_reverse function in APL.
* [array\_rotate\_left](https://axiom.co/docs/apl/scalar-functions/array-functions/array-rotate-left.md): This page explains how to use the array\_rotate\_left function in APL.
* [array\_rotate\_right](https://axiom.co/docs/apl/scalar-functions/array-functions/array-rotate-right.md): This page explains how to use the array\_rotate\_right function in APL.
* [array\_select\_dict](https://axiom.co/docs/apl/scalar-functions/array-functions/array-select-dict.md): This page explains how to use the array\_select\_dict function in APL.
* [array\_shift\_left](https://axiom.co/docs/apl/scalar-functions/array-functions/array-shift-left.md): This page explains how to use the array\_shift\_left function in APL.
* [array\_shift\_right](https://axiom.co/docs/apl/scalar-functions/array-functions/array-shift-right.md): This page explains how to use the array\_shift\_right function in APL.
* [array\_slice](https://axiom.co/docs/apl/scalar-functions/array-functions/array-slice.md): This page explains how to use the array\_slice function in APL.
* [array\_sort\_asc](https://axiom.co/docs/apl/scalar-functions/array-functions/array-sort-asc.md): This page explains how to use the array\_sort\_asc function in APL.
* [array\_sort\_desc](https://axiom.co/docs/apl/scalar-functions/array-functions/array-sort-desc.md): This page explains how to use the array\_sort\_desc function in APL.
* [array\_split](https://axiom.co/docs/apl/scalar-functions/array-functions/array-split.md): This page explains how to use the array\_split function in APL.
* [array\_sum](https://axiom.co/docs/apl/scalar-functions/array-functions/array-sum.md): This page explains how to use the array\_sum function in APL.
* [bag\_has\_key](https://axiom.co/docs/apl/scalar-functions/array-functions/bag-has-key.md): This page explains how to use the bag\_has\_key function in APL.
* [bag\_keys](https://axiom.co/docs/apl/scalar-functions/array-functions/bag-keys.md): This page explains how to use the bag\_keys function in APL.
* [bag\_pack](https://axiom.co/docs/apl/scalar-functions/array-functions/bag-pack.md): This page explains how to use the bag\_pack and pack functions in APL.
* [bag\_zip](https://axiom.co/docs/apl/scalar-functions/array-functions/bag-zip.md): This page explains how to use the bag\_zip function in APL.
* [isarray](https://axiom.co/docs/apl/scalar-functions/array-functions/isarray.md): This page explains how to use the isarray function in APL.
* [len](https://axiom.co/docs/apl/scalar-functions/array-functions/len.md): This page explains how to use the len function in APL.
* [pack\_array](https://axiom.co/docs/apl/scalar-functions/array-functions/pack-array.md): This page explains how to use the pack\_array function in APL.
* [pack\_dictionary](https://axiom.co/docs/apl/scalar-functions/array-functions/pack-dictionary.md): This page explains how to use the pack\_dictionary function in APL.
* [strcat\_array](https://axiom.co/docs/apl/scalar-functions/array-functions/strcat-array.md): This page explains how to use the strcat\_array function in APL.
* [Conditional functions](https://axiom.co/docs/apl/scalar-functions/conditional-function.md): Learn how to use and combine different conditional functions in APL
* [Conversion functions](https://axiom.co/docs/apl/scalar-functions/conversion-functions.md): Learn how to use and combine different conversion functions in APL
* [toarray](https://axiom.co/docs/apl/scalar-functions/conversion-functions/toarray.md): This page explains how to use the toarray function in APL.
* [todynamic](https://axiom.co/docs/apl/scalar-functions/conversion-functions/todynamic.md): This page explains how to use the todynamic function in APL.
* [Datetime functions](https://axiom.co/docs/apl/scalar-functions/datetime-functions.md): Learn how to use and combine different timespan functions in APL
* [unixtime\_microseconds\_todatetime](https://axiom.co/docs/apl/scalar-functions/datetime-functions/unixtime-microseconds-todatetime.md): This page explains how to use the unixtime\_microseconds\_todatetime function in APL.
* [unixtime\_milliseconds\_todatetime](https://axiom.co/docs/apl/scalar-functions/datetime-functions/unixtime-milliseconds-todatetime.md): This page explains how to use the unixtime\_milliseconds\_todatetime function in APL.
* [unixtime\_nanoseconds\_todatetime](https://axiom.co/docs/apl/scalar-functions/datetime-functions/unixtime-nanoseconds-todatetime.md): This page explains how to use the unixtime\_nanoseconds\_todatetime function in APL.
* [unixtime\_seconds\_todatetime](https://axiom.co/docs/apl/scalar-functions/datetime-functions/unixtime-seconds-todatetime.md): This page explains how to use the unixtime\_seconds\_todatetime function in APL.
* [week\_of\_year](https://axiom.co/docs/apl/scalar-functions/datetime-functions/week-of-year.md): This page explains how to use the week\_of\_year function in APL.
* [GenAI functions](https://axiom.co/docs/apl/scalar-functions/genai-functions.md): This page provides an overview of GenAI functions in APL for analyzing and processing GenAI conversation data.
* [genai\_concat\_contents](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-concat-contents.md): This page explains how to use the genai\_concat\_contents function in APL.
* [genai\_conversation\_turns](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-conversation-turns.md): This page explains how to use the genai\_conversation\_turns function in APL.
* [genai\_cost](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-cost.md): This page explains how to use the genai\_cost function in APL.
* [genai\_estimate\_tokens](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-estimate-tokens.md): This page explains how to use the genai\_estimate\_tokens function in APL.
* [genai\_extract\_assistant\_response](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-extract-assistant-response.md): This page explains how to use the genai\_extract\_assistant\_response function in APL.
* [genai\_extract\_function\_results](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-extract-function-results.md): This page explains how to use the genai\_extract\_function\_results function in APL.
* [genai\_extract\_system\_prompt](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-extract-system-prompt.md): This page explains how to use the genai\_extract\_system\_prompt function in APL.
* [genai\_extract\_tool\_calls](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-extract-tool-calls.md): This page explains how to use the genai\_extract\_tool\_calls function in APL.
* [genai\_extract\_user\_prompt](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-extract-user-prompt.md): This page explains how to use the genai\_extract\_user\_prompt function in APL.
* [genai\_get\_content\_by\_index](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-get-content-by-index.md): This page explains how to use the genai\_get\_content\_by\_index function in APL.
* [genai\_get\_content\_by\_role](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-get-content-by-role.md): This page explains how to use the genai\_get\_content\_by\_role function in APL.
* [genai\_get\_pricing](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-get-pricing.md): This page explains how to use the genai\_get\_pricing function in APL.
* [genai\_get\_role](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-get-role.md): This page explains how to use the genai\_get\_role function in APL.
* [genai\_has\_tool\_calls](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-has-tool-calls.md): This page explains how to use the genai\_has\_tool\_calls function in APL.
* [genai\_input\_cost](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-input-cost.md): This page explains how to use the genai\_input\_cost function in APL.
* [genai\_is\_truncated](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-is-truncated.md): This page explains how to use the genai\_is\_truncated function in APL.
* [genai\_message\_roles](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-message-roles.md): This page explains how to use the genai\_message\_roles function in APL.
* [genai\_output\_cost](https://axiom.co/docs/apl/scalar-functions/genai-functions/genai-output-cost.md): This page explains how to use the genai\_output\_cost function in APL.
* [Hash functions](https://axiom.co/docs/apl/scalar-functions/hash-functions.md): Learn how to use and combine various hash functions in APL
* [hash](https://axiom.co/docs/apl/scalar-functions/hash-functions/hash.md): This page explains how to use the hash function in APL.
* [IP functions](https://axiom.co/docs/apl/scalar-functions/ip-functions.md): This section explains how to use IP functions in APL.
* [format\_ipv4](https://axiom.co/docs/apl/scalar-functions/ip-functions/format-ipv4.md): This page explains how to use the format\_ipv4 function in APL.
* [format\_ipv4\_mask](https://axiom.co/docs/apl/scalar-functions/ip-functions/format-ipv4-mask.md): This page explains how to use the format\_ipv4\_mask function in APL.
* [geo\_info\_from\_ip\_address](https://axiom.co/docs/apl/scalar-functions/ip-functions/geo-info-from-ip-address.md): This page explains how to use the geo\_info\_from\_ip\_address function in APL.
* [has\_any\_ipv4](https://axiom.co/docs/apl/scalar-functions/ip-functions/has-any-ipv4.md): This page explains how to use the has\_any\_ipv4 function in APL.
* [has\_any\_ipv4\_prefix](https://axiom.co/docs/apl/scalar-functions/ip-functions/has-any-ipv4-prefix.md): This page explains how to use the has\_any\_ipv4\_prefix function in APL.
* [has\_ipv4](https://axiom.co/docs/apl/scalar-functions/ip-functions/has-ipv4.md): This page explains how to use the has\_ipv4 function in APL.
* [has\_ipv4\_prefix](https://axiom.co/docs/apl/scalar-functions/ip-functions/has-ipv4-prefix.md): This page explains how to use the has\_ipv4\_prefix function in APL.
* [ipv4\_compare](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv4-compare.md): This page explains how to use the ipv4\_compare function in APL.
* [ipv4\_is\_in\_any\_range](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv4-is-in-any-range.md): This page explains how to use the ipv4\_is\_in\_any\_range function in APL.
* [ipv4\_is\_in\_range](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv4-is-in-range.md): This page explains how to use the ipv4\_is\_in\_range function in APL.
* [ipv4\_is\_match](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv4-is-match.md): This page explains how to use the ipv4\_is\_match function in APL.
* [ipv4\_is\_private](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv4-is-private.md): This page explains how to use the ipv4\_is\_private function in APL.
* [ipv4\_netmask\_suffix](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv4-netmask-suffix.md): This page explains how to use the ipv4\_netmask\_suffix function in APL.
* [ipv6\_compare](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv6-compare.md): This page explains how to use the ipv6\_compare function in APL.
* [ipv6\_is\_in\_any\_range](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv6-is-in-any-range.md): This page explains how to use the ipv6\_is\_in\_any\_range function in APL.
* [ipv6\_is\_in\_range](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv6-is-in-range.md): This page explains how to use the ipv6\_is\_in\_range function in APL.
* [ipv6\_is\_match](https://axiom.co/docs/apl/scalar-functions/ip-functions/ipv6-is-match.md): This page explains how to use the ipv6\_is\_match function in APL.
* [parse\_ipv4](https://axiom.co/docs/apl/scalar-functions/ip-functions/parse-ipv4.md): This page explains how to use the parse\_ipv4 function in APL.
* [parse\_ipv4\_mask](https://axiom.co/docs/apl/scalar-functions/ip-functions/parse-ipv4-mask.md): This page explains how to use the parse\_ipv4\_mask function in APL.
* [Mathematical functions](https://axiom.co/docs/apl/scalar-functions/mathematical-functions.md): Learn how to use and combine different mathematical functions in APL.
* [max\_of](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/max-of.md): This page explains how to use the max\_of function in APL.
* [min\_of](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/min-of.md): This page explains how to use the min\_of function in APL.
* [rand](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/rand.md): This page explains how to use the rand function in APL.
* [range](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/range.md): This page explains how to use the range function in APL.
* [set\_difference](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/set-difference.md): This page explains how to use the set\_difference function in APL.
* [set\_has\_element](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/set-has-element.md): This page explains how to use the set\_has\_element function in APL.
* [set\_intersect](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/set-intersect.md): This page explains how to use the set\_intersect function in APL.
* [set\_union](https://axiom.co/docs/apl/scalar-functions/mathematical-functions/set-union.md): This page explains how to use the set\_union function in APL.
* [column\_ifexists](https://axiom.co/docs/apl/scalar-functions/metadata-functions/column-ifexists.md): This page explains how to use the column\_ifexists function in APL.
* [cursor\_current](https://axiom.co/docs/apl/scalar-functions/metadata-functions/cursor-current.md): This page explains how to use the cursor\_current function in APL.
* [ingestion\_time](https://axiom.co/docs/apl/scalar-functions/metadata-functions/ingestion-time.md): This page explains how to use the ingestion\_time function in APL.
* [Pair functions](https://axiom.co/docs/apl/scalar-functions/pair-functions.md): Learn how to use and combine different pair functions in APL
* [find\_pair](https://axiom.co/docs/apl/scalar-functions/pair-functions/find-pair.md): This page explains how to use the find\_pair function in APL.
* [Rounding functions](https://axiom.co/docs/apl/scalar-functions/rounding-functions.md): Learn how to use and combine different rounding functions in APL
* [SQL functions](https://axiom.co/docs/apl/scalar-functions/sql-functions.md): Learn how to use SQL functions in APL
* [String functions](https://axiom.co/docs/apl/scalar-functions/string-functions.md): Learn how to use and combine different string functions in APL
* [base64\_decode\_toarray](https://axiom.co/docs/apl/scalar-functions/string-functions/base64-decode-toarray.md): This page explains how to use the base64\_decode\_toarray function in APL.
* [base64\_decode\_tostring](https://axiom.co/docs/apl/scalar-functions/string-functions/base64-decode-tostring.md): This page explains how to use the base64\_decode\_tostring function in APL.
* [base64\_encode\_fromarray](https://axiom.co/docs/apl/scalar-functions/string-functions/base64-encode-fromarray.md): This page explains how to use the base64\_encode\_fromarray function in APL.
* [base64\_encode\_tostring](https://axiom.co/docs/apl/scalar-functions/string-functions/base64-encode-tostring.md): This page explains how to use the base64\_encode\_tostring function in APL.
* [coalesce](https://axiom.co/docs/apl/scalar-functions/string-functions/coalesce.md): This page explains how to use the coalesce function in APL.
* [countof](https://axiom.co/docs/apl/scalar-functions/string-functions/countof.md): This page explains how to use the countof function in APL.
* [countof\_regex](https://axiom.co/docs/apl/scalar-functions/string-functions/countof-regex.md): This page explains how to use the countof\_regex function in APL.
* [extract](https://axiom.co/docs/apl/scalar-functions/string-functions/extract.md): This page explains how to use the extract function in APL.
* [extract\_all](https://axiom.co/docs/apl/scalar-functions/string-functions/extract-all.md): This page explains how to use the extract\_all function in APL.
* [format\_bytes](https://axiom.co/docs/apl/scalar-functions/string-functions/format-bytes.md): This page explains how to use the format\_bytes function in APL.
* [format\_url](https://axiom.co/docs/apl/scalar-functions/string-functions/format-url.md): This page explains how to use the format\_url function in APL.
* [gettype](https://axiom.co/docs/apl/scalar-functions/string-functions/gettype.md): This page explains how to use the gettype function in APL.
* [indexof](https://axiom.co/docs/apl/scalar-functions/string-functions/indexof.md): This page explains how to use the indexof function in APL.
* [indexof\_regex](https://axiom.co/docs/apl/scalar-functions/string-functions/indexof-regex.md): This page explains how to use the indexof\_regex function in APL.
* [isascii](https://axiom.co/docs/apl/scalar-functions/string-functions/isascii.md): This page explains how to use the isascii function in APL.
* [isempty](https://axiom.co/docs/apl/scalar-functions/string-functions/isempty.md): This page explains how to use the isempty function in APL.
* [isnotempty](https://axiom.co/docs/apl/scalar-functions/string-functions/isnotempty.md): This page explains how to use the isnotempty function in APL.
* [isnotnull](https://axiom.co/docs/apl/scalar-functions/string-functions/isnotnull.md): This page explains how to use the isnotnull function in APL.
* [isnull](https://axiom.co/docs/apl/scalar-functions/string-functions/isnull.md): This page explains how to use the isnull function in APL.
* [parse\_bytes](https://axiom.co/docs/apl/scalar-functions/string-functions/parse-bytes.md): This page explains how to use the parse\_bytes function in APL.
* [parse\_csv](https://axiom.co/docs/apl/scalar-functions/string-functions/parse-csv.md): This page explains how to use the parse\_csv function in APL.
* [parse\_json](https://axiom.co/docs/apl/scalar-functions/string-functions/parse-json.md): This page explains how to use the parse\_json function in APL.
* [parse\_path](https://axiom.co/docs/apl/scalar-functions/string-functions/parse-path.md): This page explains how to use the parse\_path function in APL.
* [parse\_url](https://axiom.co/docs/apl/scalar-functions/string-functions/parse-url.md): This page explains how to use the parse\_url function in APL.
* [parse\_urlquery](https://axiom.co/docs/apl/scalar-functions/string-functions/parse-urlquery.md): This page explains how to use the parse\_urlquery function in APL.
* [quote](https://axiom.co/docs/apl/scalar-functions/string-functions/quote.md): This page explains how to use the quote function in APL.
* [regex\_quote](https://axiom.co/docs/apl/scalar-functions/string-functions/regex-quote.md): This page explains how to use the regex\_quote function in APL.
* [replace](https://axiom.co/docs/apl/scalar-functions/string-functions/replace.md): This page explains how to use the replace function in APL.
* [replace\_regex](https://axiom.co/docs/apl/scalar-functions/string-functions/replace-regex.md): This page explains how to use the replace\_regex function in APL.
* [replace\_string](https://axiom.co/docs/apl/scalar-functions/string-functions/replace-string.md): This page explains how to use the replace\_string function in APL.
* [reverse](https://axiom.co/docs/apl/scalar-functions/string-functions/reverse.md): This page explains how to use the reverse function in APL.
* [split](https://axiom.co/docs/apl/scalar-functions/string-functions/split.md): This page explains how to use the split function in APL.
* [strcat](https://axiom.co/docs/apl/scalar-functions/string-functions/strcat.md): This page explains how to use the strcat function in APL.
* [strcat\_delim](https://axiom.co/docs/apl/scalar-functions/string-functions/strcat-delim.md): This page explains how to use the strcat\_delim function in APL.
* [strcmp](https://axiom.co/docs/apl/scalar-functions/string-functions/strcmp.md): This page explains how to use the strcmp function in APL.
* [string\_size](https://axiom.co/docs/apl/scalar-functions/string-functions/string-size.md): This page explains how to use the string\_size function in APL.
* [strip\_ansi\_escapes](https://axiom.co/docs/apl/scalar-functions/string-functions/strip-ansi-escapes.md): This page explains how to use the strip\_ansi\_escapes function in APL.
* [strlen](https://axiom.co/docs/apl/scalar-functions/string-functions/strlen.md): This page explains how to use the strlen function in APL.
* [strrep](https://axiom.co/docs/apl/scalar-functions/string-functions/strrep.md): This page explains how to use the strrep function in APL.
* [substring](https://axiom.co/docs/apl/scalar-functions/string-functions/substring.md): This page explains how to use the substring function in APL.
* [tolower](https://axiom.co/docs/apl/scalar-functions/string-functions/tolower.md): This page explains how to use the tolower function in APL.
* [totitle](https://axiom.co/docs/apl/scalar-functions/string-functions/totitle.md): This page explains how to use the totitle function in APL.
* [toupper](https://axiom.co/docs/apl/scalar-functions/string-functions/toupper.md): This page explains how to use the toupper function in APL.
* [translate](https://axiom.co/docs/apl/scalar-functions/string-functions/translate.md): This page explains how to use the translate function in APL.
* [trim](https://axiom.co/docs/apl/scalar-functions/string-functions/trim.md): This page explains how to use the trim function in APL.
* [trim\_end](https://axiom.co/docs/apl/scalar-functions/string-functions/trim-end.md): This page explains how to use the trim\_end function in APL.
* [trim\_end\_regex](https://axiom.co/docs/apl/scalar-functions/string-functions/trim-end-regex.md): This page explains how to use the trim\_end\_regex function in APL.
* [trim\_regex](https://axiom.co/docs/apl/scalar-functions/string-functions/trim-regex.md): This page explains how to use the trim\_regex function in APL.
* [trim\_space](https://axiom.co/docs/apl/scalar-functions/string-functions/trim-space.md): This page explains how to use the trim\_space function in APL.
* [trim\_start](https://axiom.co/docs/apl/scalar-functions/string-functions/trim-start.md): This page explains how to use the trim\_start function in APL.
* [trim\_start\_regex](https://axiom.co/docs/apl/scalar-functions/string-functions/trim-start-regex.md): This page explains how to use the trim\_start\_regex function in APL.
* [unicode\_codepoints\_from\_string](https://axiom.co/docs/apl/scalar-functions/string-functions/unicode-codepoints-from-string.md): This page explains how to use the unicode\_codepoints\_from\_string function in APL.
* [unicode\_codepoints\_to\_string](https://axiom.co/docs/apl/scalar-functions/string-functions/unicode-codepoints-to-string.md): This page explains how to use the unicode\_codepoints\_to\_string function in APL.
* [url\_decode](https://axiom.co/docs/apl/scalar-functions/string-functions/url-decode.md): This page explains how to use the url\_decode function in APL.
* [url\_encode](https://axiom.co/docs/apl/scalar-functions/string-functions/url-encode.md): This page explains how to use the url\_encode function in APL.
* [Time series funtions](https://axiom.co/docs/apl/scalar-functions/time-series/overview.md): This section explains how to use time series functions in APL.
* [series\_abs](https://axiom.co/docs/apl/scalar-functions/time-series/series-abs.md): This page explains how to use the series\_abs function in APL.
* [series\_acos](https://axiom.co/docs/apl/scalar-functions/time-series/series-acos.md): This page explains how to use the series\_acos function in APL.
* [series\_add](https://axiom.co/docs/apl/scalar-functions/time-series/series-add.md): This page explains how to use the series\_add function in APL.
* [series\_asin](https://axiom.co/docs/apl/scalar-functions/time-series/series-asin.md): This page explains how to use the series\_asin function in APL.
* [series\_atan](https://axiom.co/docs/apl/scalar-functions/time-series/series-atan.md): This page explains how to use the series\_atan function in APL.
* [series\_ceiling](https://axiom.co/docs/apl/scalar-functions/time-series/series-ceiling.md): This page explains how to use the series\_ceiling function in APL.
* [series\_cos](https://axiom.co/docs/apl/scalar-functions/time-series/series-cos.md): This page explains how to use the series\_cos function in APL.
* [series\_cosine\_similarity](https://axiom.co/docs/apl/scalar-functions/time-series/series-cosine-similarity.md): This page explains how to use the series\_cosine\_similarity function in APL.
* [series\_divide](https://axiom.co/docs/apl/scalar-functions/time-series/series-divide.md): This page explains how to use the series\_divide function in APL.
* [series\_dot\_product](https://axiom.co/docs/apl/scalar-functions/time-series/series-dot-product.md): This page explains how to use the series\_dot\_product function in APL.
* [series\_equals](https://axiom.co/docs/apl/scalar-functions/time-series/series-equals.md): This page explains how to use the series\_equals function in APL.
* [series\_exp](https://axiom.co/docs/apl/scalar-functions/time-series/series-exp.md): This page explains how to use the series\_exp function in APL.
* [series\_fft](https://axiom.co/docs/apl/scalar-functions/time-series/series-fft.md): This page explains how to use the series\_fft function in APL.
* [series\_fill\_backward](https://axiom.co/docs/apl/scalar-functions/time-series/series-fill-backward.md): This page explains how to use the series\_fill\_backward function in APL.
* [series\_fill\_const](https://axiom.co/docs/apl/scalar-functions/time-series/series-fill-const.md): This page explains how to use the series\_fill\_const function in APL.
* [series\_fill\_forward](https://axiom.co/docs/apl/scalar-functions/time-series/series-fill-forward.md): This page explains how to use the series\_fill\_forward function in APL.
* [series\_fill\_linear](https://axiom.co/docs/apl/scalar-functions/time-series/series-fill-linear.md): This page explains how to use the series\_fill\_linear function in APL.
* [series\_fir](https://axiom.co/docs/apl/scalar-functions/time-series/series-fir.md): This page explains how to use the series\_fir function in APL.
* [series\_floor](https://axiom.co/docs/apl/scalar-functions/time-series/series-floor.md): This page explains how to use the series\_floor function in APL.
* [series\_greater](https://axiom.co/docs/apl/scalar-functions/time-series/series-greater.md): This page explains how to use the series\_greater function in APL.
* [series\_greater\_equals](https://axiom.co/docs/apl/scalar-functions/time-series/series-greater-equals.md): This page explains how to use the series\_greater\_equals function in APL.
* [series\_ifft](https://axiom.co/docs/apl/scalar-functions/time-series/series-ifft.md): This page explains how to use the series\_ifft function in APL.
* [series\_iir](https://axiom.co/docs/apl/scalar-functions/time-series/series-iir.md): This page explains how to use the series\_iir function in APL.
* [series\_less](https://axiom.co/docs/apl/scalar-functions/time-series/series-less.md): This page explains how to use the series\_less function in APL.
* [series\_less\_equals](https://axiom.co/docs/apl/scalar-functions/time-series/series-less-equals.md): This page explains how to use the series\_less\_equals function in APL.
* [series\_log](https://axiom.co/docs/apl/scalar-functions/time-series/series-log.md): This page explains how to use the series\_log function in APL.
* [series\_magnitude](https://axiom.co/docs/apl/scalar-functions/time-series/series-magnitude.md): This page explains how to use the series\_magnitude function in APL.
* [series\_max](https://axiom.co/docs/apl/scalar-functions/time-series/series-max.md): This page explains how to use the series\_max function in APL.
* [series\_min](https://axiom.co/docs/apl/scalar-functions/time-series/series-min.md): This page explains how to use the series\_min function in APL.
* [series\_multiply](https://axiom.co/docs/apl/scalar-functions/time-series/series-multiply.md): This page explains how to use the series\_multiply function in APL.
* [series\_not\_equals](https://axiom.co/docs/apl/scalar-functions/time-series/series-not-equals.md): This page explains how to use the series\_not\_equals function in APL.
* [series\_pearson\_correlation](https://axiom.co/docs/apl/scalar-functions/time-series/series-pearson-correlation.md): This page explains how to use the series\_pearson\_correlation function in APL.
* [series\_pow](https://axiom.co/docs/apl/scalar-functions/time-series/series-pow.md): This page explains how to use the series\_pow function in APL.
* [series\_sign](https://axiom.co/docs/apl/scalar-functions/time-series/series-sign.md): This page explains how to use the series\_sign function in APL.
* [series\_sin](https://axiom.co/docs/apl/scalar-functions/time-series/series-sin.md): This page explains how to use the series\_sin function in APL.
* [series\_stats](https://axiom.co/docs/apl/scalar-functions/time-series/series-stats.md): This page explains how to use the series\_stats function in APL.
* [series\_stats\_dynamic](https://axiom.co/docs/apl/scalar-functions/time-series/series-stats-dynamic.md): This page explains how to use the series\_stats\_dynamic function in APL.
* [series\_subtract](https://axiom.co/docs/apl/scalar-functions/time-series/series-subtract.md): This page explains how to use the series\_subtract function in APL.
* [series\_sum](https://axiom.co/docs/apl/scalar-functions/time-series/series-sum.md): This page explains how to use the series\_sum function in APL.
* [series\_tan](https://axiom.co/docs/apl/scalar-functions/time-series/series-tan.md): This page explains how to use the series\_tan function in APL.
* [Type funtions](https://axiom.co/docs/apl/scalar-functions/type-functions.md): This section explains how to use type functions in APL.
* [iscc](https://axiom.co/docs/apl/scalar-functions/type-functions/iscc.md): This page explains how to use the iscc function in APL to check if a string is a valid credit card number.
* [isimei](https://axiom.co/docs/apl/scalar-functions/type-functions/isimei.md): This page explains how to use the isimei function in APL.
* [ismap](https://axiom.co/docs/apl/scalar-functions/type-functions/ismap.md): This page explains how to use the ismap function in APL.
* [isreal](https://axiom.co/docs/apl/scalar-functions/type-functions/isreal.md): This page explains how to use the isreal function in APL.
* [isstring](https://axiom.co/docs/apl/scalar-functions/type-functions/isstring.md): This page explains how to use the isstring function in APL.
* [isutf8](https://axiom.co/docs/apl/scalar-functions/type-functions/isutf8.md): This page explains how to use the isutf8 function in APL.
* [Logical operators](https://axiom.co/docs/apl/scalar-operators/logical-operators.md): Learn how to use and combine different logical operators in APL.
* [Numerical operators](https://axiom.co/docs/apl/scalar-operators/numerical-operators.md): Learn how to use and combine numerical operators in APL.
* [String operators](https://axiom.co/docs/apl/scalar-operators/string-operators.md): Learn how to use and combine different query operators for searching string data types.
* [count](https://axiom.co/docs/apl/tabular-operators/count-operator.md): This page explains how to use the count operator function in APL.
* [distinct](https://axiom.co/docs/apl/tabular-operators/distinct-operator.md): This page explains how to use the distinct operator function in APL.
* [extend](https://axiom.co/docs/apl/tabular-operators/extend-operator.md): This page explains how to use the extend operator in APL.
* [extend-valid](https://axiom.co/docs/apl/tabular-operators/extend-valid-operator.md): This page explains how to use the extend-valid operator in APL.
* [externaldata](https://axiom.co/docs/apl/tabular-operators/externaldata-operator.md): This page explains how to use the externaldata operator in APL.
* [getschema](https://axiom.co/docs/apl/tabular-operators/getschema-operator.md): This page explains how to use the getschema operator in APL.
* [join](https://axiom.co/docs/apl/tabular-operators/join-operator.md): This page explains how to use the join operator in APL.
* [limit](https://axiom.co/docs/apl/tabular-operators/limit-operator.md): This page explains how to use the limit operator in APL.
* [lookup](https://axiom.co/docs/apl/tabular-operators/lookup-operator.md): This page explains how to use the lookup operator in APL.
* [make-series](https://axiom.co/docs/apl/tabular-operators/make-series.md): This page explains how to use the make-series operator in APL.
* [mv-expand](https://axiom.co/docs/apl/tabular-operators/mv-expand.md): This page explains how to use the mv-expand operator in APL.
* [order](https://axiom.co/docs/apl/tabular-operators/order-operator.md): This page explains how to use the order operator in APL.
* [Tabular operators](https://axiom.co/docs/apl/tabular-operators/overview.md): This section explains how to use and combine tabular operators in APL.
* [parse-kv](https://axiom.co/docs/apl/tabular-operators/parse-kv.md): This page explains how to use the parse-kv operator in APL.
* [parse](https://axiom.co/docs/apl/tabular-operators/parse-operator.md): This page explains how to use the parse operator function in APL.
* [parse-where](https://axiom.co/docs/apl/tabular-operators/parse-where.md): This page explains how to use the parse-where operator in APL.
* [project-away](https://axiom.co/docs/apl/tabular-operators/project-away-operator.md): This page explains how to use the project-away operator function in APL.
* [project-keep](https://axiom.co/docs/apl/tabular-operators/project-keep-operator.md): This page explains how to use the project-keep operator function in APL.
* [project](https://axiom.co/docs/apl/tabular-operators/project-operator.md): This page explains how to use the project operator in APL.
* [project-rename](https://axiom.co/docs/apl/tabular-operators/project-rename.md): This page explains how to use the project-rename operator in APL.
* [project-reorder](https://axiom.co/docs/apl/tabular-operators/project-reorder-operator.md): This page explains how to use the project-reorder operator in APL.
* [redact](https://axiom.co/docs/apl/tabular-operators/redact-operator.md): This page explains how to use the redact operator in APL.
* [sample](https://axiom.co/docs/apl/tabular-operators/sample-operator.md): This page explains how to use the sample operator function in APL.
* [search](https://axiom.co/docs/apl/tabular-operators/search-operator.md): This page explains how to use the search operator in APL.
* [sort](https://axiom.co/docs/apl/tabular-operators/sort-operator.md): This page explains how to use the sort operator function in APL.
* [summarize](https://axiom.co/docs/apl/tabular-operators/summarize-operator.md): This page explains how to use the summarize operator function in APL.
* [take](https://axiom.co/docs/apl/tabular-operators/take-operator.md): This page explains how to use the take operator in APL.
* [top](https://axiom.co/docs/apl/tabular-operators/top-operator.md): This page explains how to use the top operator function in APL.
* [union](https://axiom.co/docs/apl/tabular-operators/union-operator.md): This page explains how to use the union operator in APL.
* [where](https://axiom.co/docs/apl/tabular-operators/where-operator.md): This page explains how to use the where operator in APL.
* [Example queries](https://axiom.co/docs/apl/tutorial.md): Explore how to use APL in Axiom’s Query tab to run queries using Tabular Operators, Scalar Functions, and Aggregation Functions.


Built with [Mintlify](https://mintlify.com).