Copy as Markdown[Open in ChatGPT](https://chatgpt.com/?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fdataprime%2Flanguage-reference%2Fcommands-reference%2Fchoose.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)[Open in Claude](https://claude.ai/new?q=Read%20https%3A%2F%2Fcoralogix.com%2Fdocs%2Fdataprime%2Flanguage-reference%2Fcommands-reference%2Fchoose.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.) # `choose` ## Description The `choose` command removes all keypaths **not explicitly specified**. This allows you to extract and reshape only the data you need from a larger log document. Note The `choose` command supports nested key paths and aliasing in the output, making it useful for simplifying complex documents. ## Syntax ``` (choose|select) [as ], [as ], ... ``` ## Example **Use case: Extract, flatten, and transform key values from log documents** We have logs containing detailed HTTP request metadata, but we only want to keep a few key fields—specifically the request path, status code, and number of bytes received. We’ll also add a static field to mark the report author and perform a calculation to convert bytes to megabytes. ### Example data ``` { "status_code": 200, "user": "Chris", "path": "/home", "http_request": { "metrics": { "bytes_metrics": { "bytes_received": 57819 } } } } ``` ### Example query ``` choose status_code, user as report_author ``` ### Example output ``` { "status_code": 200, "report_author": "Chris" } ``` The `choose` command extracts only the requested fields, flattens nested keypaths, adds a calculated value, and includes a constant metadata field for easy tracking or reporting.