# VALUEIN

Takes at least 2 arguments, where the first argument is a multi-valued column, and the following arguments are constant values. The transform function will filter the value from the multi-valued column with the given constant values. The `VALUEIN` transform function is especially useful when the same multi-valued column is both filtering column and grouping column.

## Signature

> VALUEIN('colName', value1, value2,...)

## Usage Examples

These examples are based on the [Hybrid Quick Start](https://docs.pinot.apache.org/release-0.10.0/basics/getting-started/quick-start#hybrid).

```sql
SELECT VALUEIN(RandomAirports, 'SEA') as airport, count(*)
FROM airlineStats 
GROUP BY airport
```

| airport | count(\*) |
| ------- | --------- |
| SEA     | 4858      |

```sql
SELECT VALUEIN(RandomAirports, 'SEA', 'PSC') as airport, count(*)
FROM airlineStats 
GROUP BY airport
```

| airport | count(\*) |
| ------- | --------- |
| PSC     | 4832      |
| SEA     | 4858      |

{% hint style="info" %}
The `count(*)` values returned by these queries will increase each time we execute the query as data is constantly being ingested by the Hybrid Quick Start.
{% endhint %}