Page tree

 

Support | BlogContact Us | 844.332.2821

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: In general, it is easiest to manually rename columns through the application. See Rename a Column.

However, if your data contains a large number of columns, manually renaming each column may be time-consuming, and each column rename adds a step to your recipe. For wide datasets, this solution may be easier to execute and to maintain.

Steps:

  1. Open the dataset in the Transformer page.
  2. Open an application such as Microsoft Excel, which can write out CSV files. 
  3. For each column in the Transformer page, add a string name for the column in the other application. 
    1. If you are using Excel, insert this column name in the top row of the spreadsheet, with each new column added in the cell to the right of the previous one.
    2. If you are using another application, make sure that you are inserting commas between each value and putting your column names between double-quotes.

      Info

      NOTE: You may need to create a dummy second row, which forces the application to treat the imported dataset as multiple columns. Otherwise, it may treat the incoming CSV as a single columnar value.

  4. Among the column headers, locate a column by which you are comfortable sorting comfortable sorting the dataset. 
    1. For example, if your dataset includes transaction information, you may want to sort the data by the primary key TransactionId column column.
    2. Rename this column to prepend the name with with aaa. For our TransactionId column column, the new column name would be the following:

      Code Block
      aaaTransactionId
    3. This modification enables the sorting of the values in the dataset, starting with this row. All rows in the dataset are sorted according to this column. 
  5. Save the column header file in CSV format. 
  6. In the 
    D s webapp
    , create a new dataset from this CSV file. See Import Dataset Page.
  7. Load the dataset without headers. 
  8. In the Transformer page, click the Tools menu. Select Union.
  9. In the Union tool, append this dataset to the dataset that contains its headers. Include all columns. See Union Page.
  10. Execute the union to create the appended dataset. 
  11. In the append dataset, the column header row is the last one. Locate the column that contains the column header by which you want to sort. 

  12. Check the data type in this column. Change it to String type, if it is not currently. Don't worry about mismatched values; you will switch it back at the end of these steps.
  13. Next to the current column name for this value, click the drop-down caret. Select Sort ascending....
  14. The appended dataset is sorted according to the values in this column. The aaaTransactionId value  value should be at the top of the dataset.
  15. Now, use this row to create your headers:

    D code

    header

  16. Rename the column header to remove the aaa identifier identifier.

  17. Change the data type back to its original value, if necessary.