Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Use the “Worksheet” function in Cases21
    This is found in:

    • Utilities / MAZE / View and Report Data / Worksheet

    • Then choose Display SQL Table

  2. From the Worksheet window that appears on screen, click the large SQL button at the top as highlighted here:



    The following screen will appear:
    Note: The last ran query may be present


  3. Clear any existing text found in the text area and enter or paste in you new query and press the Apply button.

    Image Removed


    Image Added





  4. The SQL window should have disappeared, and then Worksheet should now be populated with data.

    Select all the data by clicking the top left corner box


  5. Now with the data selected, export the data to excel by clicking the “Export to Excel” button.


  6. Once the export has completed, navigate to the new Excel page that contains the data and save the file as a CSV (Comma delimited) (*.csv)

...