help_outline FAQ chevron_right FAQ chevron_right Detail

How do I map columns from a CSV file to fields in the Grid tool?

csv file grid columns fields map

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.