<< Click to Display Table of Contents >>
Navigation: Reference > Transforms >
Split each row into multiple rows.
Split rows before each column containing 'title':
Split rows using repeated column names:
•Split by column name:
oEach row will be split before each column that matches the criteria.
•Split a fixed number of times:
oDefine the number of times you want to split each row, starting before which column and then every N columns.
oThe split is added before the designated columns.
oSplits after the last column are ignored. So you can set times to a large number if you don't know how many columns there will be.
oFind the first column name that appears more than once and split each row before each column with that name.
•Check case sensitive to use case sensitive matching for column names.
•Comparisons of column names are whitespace sensitive.
•Splits added before the first column are ignored, as there is already a split there.
•Use New Col or Rename Cols if you need to add additional columns or rename columns before splitting rows.
•The opposite of Split Rows is Concat Rows.