About the Format Tool
The Format Tool provides a powerful way to prepare datasets by allowing bulk modifications to field names, data types, and other schema elements. This tool is especially useful for managing data with inconsistent formatting, making it easier to standardize and organize fields across large datasets.
Configuration Options
1. Replace Field Names from Row:
Select this option to replace the current field names with values from a specified row in the dataset. Enter the row number that contains the desired field names.
2. Format Steps:
Use the Add Step button to define actions for modifying fields based on specific criteria. Each step can include the following actions:
Change Type: Converts the field type to one of Savant’s supported types (Boolean, Date, DateTime, Integer, Number, Text).
Hide: Hides columns that meet your specified criteria.
Rename: Renames columns. Specify criteria such as "starts with," "ends with," or "contains" to select the fields you want to rename.
Additional Notes
Multiple Format Steps: You can add multiple steps in a single configuration to apply different actions to various fields, making it easy to handle complex formatting needs.
Field Matching Criteria: When renaming, hiding, or changing types, you can specify criteria like "starts with," "ends with," or "contains" to target specific fields, allowing for more specific bulk modifications.