All Products
Search

This Product

    Quick BI:Create and Manage Download Tasks

    Document Center

    Quick BI:Create and Manage Download Tasks

    Last Updated:Oct 31, 2024

    After the download is created, you can create and manage download tasks to download data.

    Go to the downloads page

    1. Login Quick B console.

    2. On the Quick BI product homepage, click Workbench.

    3. In the left-side navigation pane, click Downloads. image.png

    Create a download task

    • Create a download task on the editing page.

      1. Click the self-service download you want to download.

      2. On the download editing page, create a task by using one of the following paths:

        1. Path 1: Click the icon below the imagetask list to create a task. image

        2. Path 2: Click the imageicon above the task list to go to the task list, and then click Create Download Task. image

      3. Set the fetching task name and export format. The export format supports plain data Excel, formatted Excel, and CSV. image

      4. Click OK. imageYou can view the download task on the Tasks page. image

    • Use a cross table to create a download task.

      1. On the cross table editing page, enter the downloads mode as shown in the figure. image.png

        Note

        After you click downloads, a preview page appears. The style of the preview page is consistent with the content of the downloaded file.

        • Fixing does not support row-column mixing. If row-column mixing is set for a cross table, row-column mixing is canceled during fetching.

        • Advanced calculation is not supported. If advanced calculation is configured for a cross table, the advanced calculation in the table is rolled back to normal aggregation, and the fields configured for the last day are hidden.

      2. On the download preview page, create a download task by using one of the following paths:

        1. Path 1: Click the icon below the imagetask list to create a task. image

        2. Path 2: Click the imageicon above the task list to go to the task list page, and then click Create Download Task. image

      3. Set the fetching task name and export format. The export format supports plain data Excel, formatted Excel, and CSV. image

      4. Click Confirm. image

      5. You can view the tasks of the current cross table on the Tasks page. image

      6. Click Exit in the upper-right corner to go back to the editing page of the cross table. image

    Manage download tasks

    • On the Download Tasks tab of the Downloads page, find the data retrieval task that you want to download and click the Downloads icon in the Actions column. The data retrieval task is downloaded to your computer in the form of an Excel file or a CSV file. image.png

    • In the Task List of a cross table retrieval task, click the Downloads icon in the Actions column corresponding to a self-service retrieval task. The retrieval task is downloaded to your computer in the form of an Excel file or a CSV file. image

    Download format of a data retrieval task

    • Pure data Excel

      The exported data is not formatted. The file type is Excel.

    • Format Excel

      You can export data in the Data Display Format, Date Field Format, Alignment, and Field Rename formats.

      Note

      Field Rename is set in the field display content: image

      • If you set the Data Display Format parameter to Automatic and do not configure alignment methods or rename fields, the exported Excel data is not formatted. In this case, Excel with Format and Excel with Pure Data have the same effect.

      • If you set Data Display Format to Integer, Retain Decimal Places, Percentage, or Custom, or set Alignment or Rename Field to Excel, the format of the exported Excel data is retained. image

    • CSV

      The type of the exported data file is CSV.