---
title: Advanced workflows in ES|QL
description: These guides provide detailed information about more advanced workflows in ES|QL. Extract data with DISSECT and GROK: Learn how to extract and transform...
url: https://www.elastic.co/elastic/docs-builder/docs/3716/reference/query-languages/esql/esql-advanced
products:
  - Elasticsearch
applies_to:
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
---

# Advanced workflows in ES|QL
These guides provide detailed information about more advanced workflows in ES|QL.
- [Extract data with `DISSECT` and `GROK`](https://www.elastic.co/elastic/docs-builder/docs/3716/reference/query-languages/esql/esql-process-data-with-dissect-grok): Learn how to extract and transform structured data from unstructured text.
- [Augment data with `ENRICH`](https://www.elastic.co/elastic/docs-builder/docs/3716/reference/query-languages/esql/esql-enrich-data): Learn how to combine data from different indices.
- [Join data with `LOOKUP JOIN`](https://www.elastic.co/elastic/docs-builder/docs/3716/reference/query-languages/esql/esql-lookup-join): Learn how to join data from different indices.
- [Filter rows with `IN` subqueries in a `WHERE` command](https://www.elastic.co/elastic/docs-builder/docs/3716/reference/query-languages/esql/esql-in-subquery): Learn how to filter rows in the `WHERE` command using the results of another query. <applies-to>Elastic Stack: Planned</applies-to> <applies-to>Elastic Cloud Serverless: Preview</applies-to>
- [Approximate `STATS` queries](https://www.elastic.co/elastic/docs-builder/docs/3716/reference/query-languages/esql/esql-query-approximation): Learn how to obtain fast approximations of STATS queries.