Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Info

NOTE: This method applies to all columns in the dataset.

Types:

TypeDescription
Use a single row to rename columns

Specify the row number in the sample to use as the source for column names.

Info

NOTE: Source row number information must be available. See below.

Use the first row in the sample to rename columns Use the first row in the sample as the name for all columns.
Combine multiple rows to rename columns

Specify two or more rows to combine into column names. Details are below.

Info

NOTE: Source row number information must be available. See below.

Source row number information:

Info

NOTE: If source row number information is no longer available, this method cannot be used for column rename.

  • If a value is not applied for the source row number, the next row of data is used.
  • Source row numbers apply. Current row numbers may not be the same. In the data grid, mouse over the leftmost column to see available row information.
  • Each value in the row or combination of values across rows must be unique within the set of new column names.
  • The row is removed from its original position.
  • If the product is unable to find unique multi-row headers for the column, the first row of the header set is used.

Combine multiple rows:

The following transformation renames the columns in the dataset based on the values in rows 3 and 4 of the data:

D trans
p03Value3
p06NameFill across?
p01NameOption
p06ValueSelected
p03NameRow Numbers - row A
p04Value4
SearchTermRename columns
Typestep
p05NameChoose your separator
p01ValueUse row(s) as column names
p02NameType
p02ValueCombine multiple rows to name columns
p05Value'_'
p04NameRow Numbers - row B

In the above:

  • The Separator separator is defined as an underscore character (_). This value can be empty.
  • When Fill across is selected, if any row value is empty, the last non-empty value for the row in a previous column is used as part of the column header.