Integer-Based Column Reordering in Select Columns Tile

Phil_Nussbaum

Please add an option to manually reorder columns in the Select Columns tile by entering an integer position value next to each column—similar to reordering mechanisms seen in interfaces like Steam’s Wishlist or Spotify's playlist editor.

This would allow users to explicitly control column output order by position, not just by name.

Why this matters:
The recently released SQL tile supports UNION ALL, which appends rows based on column position, not column name—unlike the standard Append Rows tile. However, Magic currently offers no native way to re-order columns by index, making it difficult to:

• Prepare datasets for position-based appending
• Align inputs in a SQL UNION ALL scenario
• Enforce consistent schema shape in the visual UI

Proposed functionality:

• Add an integer input box next to each column in the Select Columns tile
• Changing the number would reorder the column list accordingly
• Drag-and-drop would still be supported as an alternative
• This order can still be overwritten downstream

Benefits:

• Enables precise control over output schema for SQL tile workflows
• Improves support for advanced logic like cross-dataset unioning
• Helps builders visually verify and manage schema order
• Similar UI can be used in the "Add Formula" tile, the drag and drop can be very clunky.

This would be a small UI enhancement with big practical benefits for advanced ETL users— especially those leveraging the SQL tile for UNION ALL logic or merging datasets with mismatched schemas.