---
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/3028/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/3028/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/3028/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/3028/reference/query-languages/esql/esql-lookup-join): Learn how to join data from different indices.