# View: nr_contribution_instruments_multi_row

**View Name:** nr_performance_nr_contribution_multi_row
**Table Source:** `Derived from: Prod.Performance_Nr_Contribution`
**File Path:** `views/nr_contribution_instruments_multi_row.view.lkml`

## Overview

- **File Size:** 715 bytes
- **Lines of Code:** 34
- **Dimensions:** 3
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- 🔑 Important: this is NOT a true PK anymore (multiple rows per ID)

## Dimensions

| Name | Type |
|------|------|
| `contribution_id` | string |
| `instrument` | string |
| `instrument_position` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Derived Table

```sql
sql:
      SELECT
        c.ID,
        f.value::string AS instrument,
        f.index AS instrument_position
      FROM FACTS.PROD.PERFORMANCE_NR_CONTRIBUTION c,
           LATERAL FLATTEN(input => c.INSTRUMENTS) f
    ;;
```