HOW TO: Multi Column Selection

HOW TO: Multi Column Selection

Columns View

You can select multiple columns using ctl + click (command on Mac) or shift + click in the columns view:

Builder

You can select multiple columns in builder using the Columns parameter (depending on the Transform) and Transform dependent parameters:

You can also select all columns in your dataset using the wildcard (*) character

The following Transforms can be used across multiple columns:

  • Drop
  • Merge
  • Move
  • Nest
  • Set. Note: when applying a Set Transform to multiple columns, your formula will need to contain the $col value (instead of column names) for that function to be applied to all columns in the Columns parameter
  • Settype
  • Unpivot

See Also