The "Select to text" instruction allows a user to query managed tables and export the results to a text (txt or csv) file.

This step is useful for exporting managed table data for consumption in other external systems and processes.

Step-by-step guide

1. Create an action step as "Multiple file manipulations".
2. Add the "Select to text" instruction from the list under the Tables section:
   
   
   
   
3. Configure the details for the instruction:
   1. Input the SQL query according to the guidelines here.
   2. Select the parameters for the output including:
      1. The delimiter, e.g. comma, tab or custom.
      2. Date data format 
      3. End of line character (default is usually sufficient)
      4. Whether to encapsulate all text fields in a given character (double quotes by default)
      5. Whether to include column headings in the output.
   3. Link a text file stored in a data step property in a SolveXia process.