> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/unnest.md).

# Unnest

Learn how to use the Unnest transformation to convert delimited values into separate rows and flatten your data.

## Use the unnest transformation

Use the **Unnest** transformation to split delimited text values into separate rows. This transformation is useful when a column contains multiple values separated by a delimiter and you want each value to appear in its own row.

You can find the **Unnest** transformation on the **Transform** tab.

### Flatten delimited values into separate rows

The following example shows order data where the **Order Tags** column contains multiple comma-separated values.

| Order ID | Customer name  | Order Tags                                         |
| -------- | -------------- | -------------------------------------------------- |
| 1        | Skylar Bennett | Express Delivery, Gift Wrap                        |
| 2        | Lisa Taylor    | Installation Service, Insurance, Extended Warranty |
| 3        | Adrian King    | Gift Wrap, Extended Warranty                       |
| 4        | Eric Solomon   | Express Delivery, Installation Service             |
| 5        | Nicole Wagner  | Insurance, Extended Warranty, Gift Wrap            |
| 6        | Oscar Ward     | Express Delivery                                   |
| 7        | Victoria Burke | Gift Wrap, Installation Service                    |
| 8        | Avery Howard   | Insurance, Extended Warranty                       |
| 9        | Anne Patel     | Express Delivery, Gift Wrap, Insurance             |
| 10       | Liam Davis     | Installation Service, Extended Warranty            |

After the **Order Tags** column is unnested, each tag appears in a separate row while the remaining column values are duplicated.

| Order ID | Customer name  | Order Tags           |
| -------- | -------------- | -------------------- |
| 1        | Skylar Bennett | Express Delivery     |
| 1        | Skylar Bennett | Gift Wrap            |
| 2        | Lisa Taylor    | Installation Service |
| 2        | Lisa Taylor    | Insurance            |
| 2        | Lisa Taylor    | Extended Warranty    |
| 3        | Adrian King    | Gift Wrap            |
| 3        | Adrian King    | Extended Warranty    |
| 4        | Eric Solomon   | Express Delivery     |
| 4        | Eric Solomon   | Installation Service |
| 5        | Nicole Wagner  | Insurance            |
| 5        | Nicole Wagner  | Extended Warranty    |
| 5        | Nicole Wagner  | Gift Wrap            |
| 6        | Oscar Ward     | Express Delivery     |
| 7        | Victoria Burke | Gift Wrap            |
| 7        | Victoria Burke | Installation Service |
| 8        | Avery Howard   | Insurance            |
| 8        | Avery Howard   | Extended Warranty    |
| 9        | Anne Patel     | Express Delivery     |
| 9        | Anne Patel     | Gift Wrap            |
| 9        | Anne Patel     | Insurance            |
| 10       | Liam Davis     | Installation Service |
| 10       | Liam Davis     | Extended Warranty    |

The following example uses the **Order Tags** calculated column, which contains multiple comma-separated values.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FHWfyqGIksUq4BJKRvMpm%2Funnest-source-order-tags.png?alt=media&amp;token=144af3f1-4761-4c96-9f3c-fab198953d79" alt=""><figcaption></figcaption></figure>

After importing the report into Infobridge, apply the **Unnest** transformation.

1. Open the query that contains the **Order Tags** column.
2. On the **Transform** tab, select **Unnest**.<br>

   <figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2F6u0tFAF3ioIAtdkj6KG7%2Funnest-result-order-tags.png?alt=media&amp;token=b84a7f8c-3ba2-4121-9df6-1124e78334f8" alt=""><figcaption></figcaption></figure>
3. In the **Unnest** dialog:
   1. Select **Order Tags** as the **Target column**.
   2. In **Delimiter**, enter a comma (`,`).

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FfRHgPs74ho7T3pFX5oiJ%2Funnest-dialog-order-tags.png?alt=media&amp;token=f2d6fbe5-d589-4aca-9dac-36979bb09275" alt=""><figcaption></figcaption></figure>

1. Select **Apply**.

The **Order Tags** column expands so that each value appears in its own row while the remaining column values are duplicated.

<figure><img src="https://257222532-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUtolck8kt8atqxFPsEBn%2Fuploads%2FIIr4FmEw7KfWWtvs17SQ%2Funnest-output-order-tags.png?alt=media&amp;token=c886e070-a5a7-4304-915b-d734691bc13e" alt=""><figcaption></figcaption></figure>

You can continue transforming the flattened data or write the results to a destination.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/unnest.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.