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 r092

D toc

Excerpt

If needed, you can clean the names of the columns in your dataset. 

When column names are sanitized:

  • alphanumeric characters and underscores (_) are permitted
  • spacebars are converted to underscores
  • all other characters are removed

Although

D s product
rtrue
supports a wider range of characters, you may wish to sanitize your column names to simplify publishing to and import into downstream systems.

Sanitize during Import

The above sanitization can be applied to your column names when the dataset is imported.

Tip

Tip: If you notice issues with references to your column names in your recipes, you may be able to fix them by re-importing the dataset and choosing to sanitize during import.

Steps:

  1. From the menubar, click Library.
  2. In the Library page, click Import Data.
  3. In the Import Data page, select the file or table to import. 
  4. Click Edit Settings
  5. In the dialog, select Remove special characters from column names.
  6. Complete the import of the dataset.

For more information, see File Import Settings.

Sanitize via Transformation

Through the Transform Builder, you can add a step to sanitize column names in your recipe.

D trans
Typeref
p01NameOption
p01ValueClean current column names
SearchTermRename by removing special characters

Tip

Tip: If you are sanitizing your column names for downstream systems, you should add this step at the end of your recipe.

You can perform more fine-grained column renaming operations. See Rename Columns.

D s also
inCQLtrue
label(label = "rename")