This feature goal is to allow input to import with columns in a different order than in the original Excel model. Milliman Mind will automatically change the imported input columns to match the Excel file/Mind order.
Add specific /Reorder flag
You must add a /Reorder flag to your grids to do so. Those grids must follow these requirements:
- Do have a /Input flag.
- Do not have /NoHeader flag.
- Do not have two columns with the same header value.
This is because the /Reorder will be based on the headers' names to match the correct columns.
Import of inputs
You can then use the input manager to import various files with matching column headers, no matter the order of these columns.
The final order, kept in Mind, will be the one from the original Excel file. If some extra columns exist in the source file, they will be skipped.
This feature can be combined with the input manager format control feature.