# 5. Insert rows from bridge In this section, we will demonstrate how to extract rows from the source visual and insert them into a target visual. For simplicity, we have used sample reports with a limited number of rows and columns. Let us now combine data from two reports by inserting the rows from source visual to the target visual. The first report contains product sales and COGS data for the *France* region (source visual), while the second report contains the same information for *all* regions (target visual). Here are the visuals:

**STEP 1:** Add the source visual to the bridge. This enables us to perform any data transformations on it if required and enables the first step for integration. **STEP 2:** Map the dimensions and measures between the source and destination visuals, ensuring a seamless integration. **STEP 3:** Insert rows from the source to the target visual using the **Insert Rows** option. {% hint style="info" %} If the source visual is already available in a bridge in the required format, you can directly start with step 2, [mapping the dimensions](#mapping-dimensions-between-the-reports). {% endhint %} {% hint style="info" %} Both the source and target visuals can be part of the same bridge. In this scenario, we can either utilize the 'Append Query' transformation option within the bridge to integrate them, or use the 'Insert Rows' feature from the Inforiver source visual while selecting the target visual from the necessary query in the bridge. {% endhint %} ### 1. Adding source visual to the bridge 1. Create a new bridge with the source visual using **InfoBridge ->** **Create Bridge** option following the steps illustrated [here](https://docs.inforiver.com/1.-create-bridge#id-1.-through-inforiver-console).

2. The bridge is created as below.

You can also transform the source data using the options in the bridge, before it is included in the target visual. ### 2. Mapping dimensions between the visuals Before combining the source and the target visuals, we must first map their respective dimensions and measures to establish their relationship, ensuring a seamless integration. 1. To map the dimensions, click **Manage Integration** in the target visual under the **InfoBridge** tab. In the side panel that opens, click **Add New.**

2. In the pop-up window, select the bridge that contains the source.

3. After selecting, the bridge details are displayed. Select the required source query within the bridge and click **Next.**

4. This navigates you to the 'Map Dimension' tab. Verify the mapping of rows, columns, and measures between the source and the destination visuals. Manually map them if required. Click **Add.**

The mapping is now done. ### 3. Insert rows from source to target 1. In the target visual, select any row and click **Insert Rows** from the **InfoBridge** tab.

2. Preview the source query and click **Save.** To add new query, click 'Add New Query'. You can add as many queries as required if you want to further add new sources.

3. The rows are successfully inserted as below. Rows inserted from the bridge source are marked with a link icon beside them.

Report with inserted rows from bridge source

{% hint style="info" %} Infobridge rows are read-only and cannot be directly edited. Values can be updated via the [adjustment workflow](https://docs.inforiver.com/infobridge-wb-matrix-only/11.-collaborative-adjustments). {% endhint %} ### Viewing lineage Click the ![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FlFuSoIL66UwZrtXTSBoO%252Fimage.png%3Falt%3Dmedia%26token%3D23fc9edb-fa72-4bfb-8560-7db0b62153e9\&width=45\&dpr=4\&quality=100\&sign=7dd4aa6a\&sv=2)icon to view and directly navigate to the source bridge and query. This enables you to trace and manage rows inserted from different bridges.

In the next section, we will look at inserting measures from one visual to another.