---
title: v1.fieldsAsCols() function
description: v1.fieldsAsCols() is a special application of pivot() that pivots input data on _field and _time columns to align fields within each input table that have the same timestamp.
url: https://docs.influxdata.com/flux/v0/stdlib/influxdata/influxdb/v1/fieldsascols/
estimated_tokens: 1147
product: InfluxDB OSS v1
version: v1
---

# v1.fieldsAsCols() function

-   Flux 0.16.0 – 0.88.0
-   View InfluxDB support

`v1.fieldsAsCols()` is a special application of `pivot()` that pivots input data on `_field` and `_time` columns to align fields within each input table that have the same timestamp.

#### Deprecated

See influxdata/influxdata/schema.fieldsAsCols.

##### Function type signature

```js
(<-tables: stream[A]) => stream[B] where A: Record, B: Record
```

For more information, see [Function type signatures](/flux/v0/function-type-signatures/).

## Parameters

### tables

Input data. Default is piped-forward data (`<-`).

## Examples

### Pivot InfluxDB fields into columns

```js
import "influxdata/influxdb/v1"

data
    |> v1.fieldsAsCols()
```

[](#view-example-input-and-output)

View example input and output

#### Input data

| _time | *_measurement | *loc | *_field | _value |
| --- | --- | --- | --- | --- |
| 2021-01-01T12:00:00Z | m | Seattle | hum | 89.2 |
| 2021-01-02T12:00:00Z | m | Seattle | hum | 90.5 |
| 2021-01-03T12:00:00Z | m | Seattle | hum | 81.0 |

| _time | *_measurement | *loc | *_field | _value |
| --- | --- | --- | --- | --- |
| 2021-01-01T12:00:00Z | m | Seattle | temp | 73.1 |
| 2021-01-02T12:00:00Z | m | Seattle | temp | 68.2 |
| 2021-01-03T12:00:00Z | m | Seattle | temp | 61.4 |

#### Output data

| _time | *_measurement | *loc | hum | temp |
| --- | --- | --- | --- | --- |
| 2021-01-01T12:00:00Z | m | Seattle | 89.2 | 73.1 |
| 2021-01-02T12:00:00Z | m | Seattle | 90.5 | 68.2 |
| 2021-01-03T12:00:00Z | m | Seattle | 81.0 | 61.4 |

#### Deprecated

`v1.fieldsAsCols()` was deprecated in **Flux v0.88.0** in favor of [`schema.fieldsAsCols()`](/flux/v0/stdlib/influxdata/influxdb/schema/fieldsascols/).

#### Not supported in the Flux REPL

`v1` functions can retrieve schema information when executed within the context of InfluxDB, but not from the [Flux REPL](/influxdb/cloud/tools/repl/).

[transformations](/flux/v0/tags/transformations/)