Docs sections
Work with data
Fields and types
Understand field types, how to correct them, how categories work, and how missing values affect analysis.
IMD detects field types from the values in each column. Correct field types matter because summaries, charts, cleaning suggestions, and AI context all depend on the table being interpreted correctly.
If a field is detected incorrectly, adjust it before generating charts or cleaning plans. Type fixes are often the fastest way to prevent confusing downstream results.
Field types
Common field types include text, number, date, boolean, enum, and other supported types. Each type changes how IMD summarizes and handles the column.
Type information is used in the Diagnostics and Summary panels to produce meaningful statistics and diagnostics.
Change field type
Use field controls or the type selector to change a field type. Changes are reflected immediately in the view and statistics.
If a field contains mixed formats, such as numbers and text together, a type change may fail or cause data anomalies.
Enums and categories
Enum fields represent a limited set of category values such as status, type, or rating. IMD shows the count and distribution of each enum value.
If category labels are inconsistent (such as "yes" and "Yes"), AI can suggest a unification approach.
Missing values
Missing values appear as empty cells or specific marker values such as N/A or NULL. IMD highlights fields with high missing value counts in diagnostics.
Before creating a cleaning plan, decide which fields with missing values need treatment and whether they should be filled, removed, or kept.