# Blending the Data

To demonstrate how the data blending works, we'll use two data sources: Airtable and Google Sheets, where the former contains the `Order` table and the latter - the `Customers` table. Notice that the `Customer ID` column in the `Orders` table refers to the `ID` in the `Customers` table.

![](/files/W9PVfZnoXJ52JH3On80c)

Once you've connected your data sources (read more on particular integrations [**here**](/user-guide/integrations.md)), proceed to the data section and pick a data source where you want to perform the blending *(you can choose either one, it's just a matter of convenience)*

![](/files/AG22iTaTxq2XjRk381Dy)

1. Create a new **Virtual Collection**
2. Name the Collection
3. Click on the `Create` button
4. You'll see all the data sources you've connected using "Sync" on the right. You can now pick the columns and use them in your query:

{% @arcade/embed flowId="fHlP2za57Nst2y8C1fW6" url="<https://app.arcade.software/share/fHlP2za57Nst2y8C1fW6>" %}

And after writing and running our query, we get the resulting table, containing `Full name` and `Country` columns from the `Customers` table together with the `Order Date` column from the `Orders` table.

![](/files/6PjHJCCAFrnhW1bKA9i2)

After saving changes, we get a collection with joined data that we can later use in the interface.


---

# Agent Instructions: 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:

```
GET https://docs.jetadmin.io/user-guide/360-data-data-blending/blending-the-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.