Exporting data from a component

Some components include an Actions > Export option to export data to a CSV file with UTF-16LE encoding.

The export option is not available if you are viewing the project on an iPad.

The following components include an Export option:
  • Data Record Displays
    • Results List - Exported data includes the displayed attributes for all exported records. You can select specific records to export.
    • Results Table - Exported data includes all columns from the available column sets. You can select specific rows to export.

      For aggregated tables, only the displayed dimensions are included in the export.

    • Record Details - While not a component, the Record Details screen is accessible from the Results List, Results Table, and Map. Exported data from this screen includes a single row for the displayed data.
  • Other Data Visualizations
    • Pivot Table- Exported data includes the data used to create the Pivot Table display.

To export data from a component:

  1. In the component Actions menu, select Export.

    The Export Data dialog displays.

  2. In the File name: field, set output file format:

    By default, the output file name is the data view name, with spaces replaced by underscores.

  3. In the File type: field, set the output type:
    • Avro saves the file as an Avro file in HDFS.
    • Delimited saves the file as a CSV.
    1. For Delimited files, set the following using drop-downs:
      • Field Delimiter - The character used to separate fields in a record. You can select Other to enter a custom character.
      • Quote Character - The character used for quotation marks, either double or single quote.
      • Multi-Value Delimiter - The character used to separate multiple values in the same multi-assign field. You can select Other to enter a custom character.

      For example, if you choose Pipe (|) , Single quote ('), and Semicolon (;), a row from the exported file might look something like:

      |'10234'|'Bourdeaux'|'Valmaison'|'Best buy';'Recommended'|'$10'|
  4. In the Export to: drop-down, select an export destination:
    • My Computer is the default option, and prompts to open or download the file, based on your browser.
    • HDFS exports the file to HDFS so that it is available to other Studio users. This option is available to Administrators and Power Users.
    1. For HDFS exports, set the following:
      • HDFS File Path - The file path on the configured HDFS export directory. Ensure that any changes return a checkmark when validating path uniqueness.
      • Create Hive table - For Avro files, select this checkbox to create a new Hive table for exported data.
    2. If you are creating a Hive table, set the name and description:
      • Hive table name: - The name of the Hive table.

        By default, this is the data view name with spaces replaced by underscores and an incremented number appended for uniqueness. Ensure that any changes return a checkmark when validating that the new path is unique.

      • Description: - A description of the table.
  5. If the component has multi-value attributes selected, then under Multi-Value Attribute Handling, click a radio button to indicate whether to leave multi-value attributes without any transformations, or to transpose columns for multi-value attributes.
    Transposing multi-value attributes adds a column for each unique value of the attribute. For each record, each column includes a Boolean value that indicates whether the attribute value is present for that record.
  6. Click Export.
    An Export Data screen displays while data is formatted and prepared for export.
  7. Save or open the exported file.

    The exact prompt varies based on your browser.