How do I map columns from a CSV file to fields in the Grid tool?
In the SQL Query field, use COL1, COL2, etc., to represent column positions in the CSV file and alias them to match Grid field names (e.g., COL1 AS GridField1). Ensure data types are compatible.