Help Center>Studio (Foundation)

Map the query fields

map step of choode define map submit approve run process

The way you map the fields from your script to your data file depends on the file type that you are using:

  • Microsoft Excel
  • Microsoft Access
  • Text file
  • SQL Server
  • SharePoint list

    The account that you use to write to SQL Server must have db_owner or db_ddladmin membership on the database that contains the target table.

    If you are using XML forms for the data file, you do not need to map the fields.

    Note: In the Mapper, you can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words, as in the screenshot below).


    In Query, users can Shift Up and Shift Down multiple rows at a time within the Mapper.