About the Unpivot Tool
The Unpivot Tool in Savant reshapes wide datasets into a longer format by converting selected fields into rows. This is useful for normalizing data and preparing it for analysis when spread across multiple fields.
Configuration Options
Name Field:
Specify the new field that will contain the former field names.
Value Field:
Choose the field that will hold the corresponding values from the unpivoted fields.
Keep Fields / Unpivot Fields:
Keep Fields: Select which fields to retain in the output alongside the unpivoted data.
Unpivot Fields: Specify which fields should be converted into rows.
