# Select Multiple Columns in FLUX

**URL:** <https://community.influxdata.com/t/select-multiple-columns-in-flux/30230>\
**Category:** InfluxDB 2\
**Tags:** flux\
**Created:** [June 8, 2023, 4:33pm UTC](https://community.influxdata.com/t/select-multiple-columns-in-flux/30230 "2023-06-08T16:33:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ajetsharwin](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/ajetsharwin/32/13686_2.png) [@ajetsharwin](https://community.influxdata.com/u/ajetsharwin)\
**Post date:** [June 8, 2023, 4:33pm UTC](https://community.influxdata.com/t/select-multiple-columns-in-flux/30230/1 "2023-06-08T16:33:30Z")

</div>

In flux, what is the boilerplate query for producing an output table which has multiple fields as columns?

ie for a given bucket and measurement if I want to select fields x1,x2,x3, how do I do this?

---

<div class="post-metadata">

**Author:** ![fercasjr](https://avatars.discourse-cdn.com/v4/letter/f/e495f1/32.png) [@fercasjr](https://community.influxdata.com/u/fercasjr)\
**Post date:** [June 9, 2023, 1:23pm UTC](https://community.influxdata.com/t/select-multiple-columns-in-flux/30230/2 "2023-06-09T13:23:29Z")

</div>

use pivot function. ` |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")`

---

<div class="post-metadata">

**Author:** ![ajetsharwin](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/ajetsharwin/32/13686_2.png) [@ajetsharwin](https://community.influxdata.com/u/ajetsharwin)\
**Post date:** [June 14, 2023, 12:04pm UTC](https://community.influxdata.com/t/select-multiple-columns-in-flux/30230/3 "2023-06-14T12:04:26Z")

</div>

More specifically,

what is the equivalent of the below InfluxQL code in influx 1 for FLUX in influx 2 :

SELECT “x1”, “x2”, “x3” FROM “db”.“measurement” WHERE time \> :dashboardTime: AND time \< :upperDashboardTime: