Skip to content
Audit Data Analytics
(864)625-2524
contact@auditdataanalytics.net
Menu
  • Home
  • Solutions
  • Blog
  • Research
  • About Us
  • Privacy
  • Download
  • Shop
    • Cart
    • Checkout
    • My Account
      • Communication preferences
  • ADA Help
Menu

How to Sort Data with ADA

Introduction

ADA (Audit Data Assistant) provides you with an easy to use tool for sorting your data.

Using the Sort Dialog

Sort lets you sort data by column in ascending or descending order:

ADA sort data dialog
Sort Grid. The grid shows which columns are being used to sort the data and the order of the column. For instance, in the screenshot above, this data file is being sorted by COUNTRY_CODE in ascending order. Ascending order is the default. To sort in descending order, simply uncheck the checkbox. It is okay to re-use a column in the sort grid if desired, however it will have no effect on the result.

Add and Remove Column Buttons. If you wish to add a column to the sort, click the Add button. To remove a column from the sort, highlight the column of choice and click the Remove button.

Output Name. Name your sorted data file. It will be saved in the project folder with a .parquet extension. Here, the output file with be named sorted zip code data.parquet.

summarize output filename
Formats Supported by Sort

ADA’s Sort utility allows you to filter Parquet data. Parquet is the format ADA uses for storing data files.

Questions

If you have questions about ADA software or you would like to know about purchasing custom ADA analytics, wonderful! Please call us at (864) 625 – 2524, and we’ll be happy to help.

fb-share-icon
Tweet
Pin Share
RSS
Follow by Email
Facebook
fb-share-icon
Twitter
Tweet
LinkedIn
Share

ADA Help Contents

ADA Overview
How to Append Data with ADA
How to Detect Duplicates with ADA
How to Evaluate a Monetary Unit Sample with ADA
How to Evaluate a Variable Sample with ADA
How to Evaluate an Attribute Sample with ADA
How to Filter Data with ADA
How to Generate Summary Statistics with ADA
How to Import Data with ADA
How to Join Data with ADA
How to Manage Columns with ADA
How to Perform Error Assurance with ADA
How to Plan a Monetary Unit Sample with ADA
How to Plan an Attribute Sample with ADA
How to Plan and Extract a Classical Variable Sample with ADA
How to Quick Export Data with ADA
How to Random Sample with ADA
How to Sort Data with ADA
How to Summarize Data with ADA
How to Write Criteria with ADA

 

 

 

fb-share-icon
Tweet
Pin Share
©2023 Audit Data Analytics Corp | Design: Newspaperly WordPress Theme