Audit Command Language – Data Import

Welcome to a new post in the series for ‘Audit Command Language Tutorial for Beginners’. In the next couple of posts, we will be covering various ways to import raw data files into an ACL project. Let’s start with something rather straightforward, i.e. delimited files.

As discussed in a previous post, delimited files are generally in a text format, with characters such as a comma, colon, ‘~’ etc. separating the columns in the data file as below:

You can follow the next steps to import a delimited file into ACL:

  1. Go to ‘File’ -> ‘New’ – > ‘Table’
    • step-1
  2. Select ‘Local’
    • step-2
  3. Select ‘Disk’
    • step-3
  4. Browse sample data file from data folder of your project
    • step-5
  5. On the next screen, select the second option
    • step-6
  6. Choose ‘Delimited Text File’ from the list file formats
    • step-7
  7. The next step, select the following:
    • Set top row as field names
    • enter the delimiter (‘|’ or comma or colon etc.)
    • Select the appropriate text qualifier
    • then choose the appropriate length for each field
  8. Save file in project folder in the ‘ACL’ folder
    • step-9
  9. The next window is the section to edit the field properties:
    • Select the type
    • rename the data field if required
    • You may also choose to ignore the field
  10. Review the fields imported with selected ACL data types in the next screen
  11. Enter the name for the table as appropriate
    • step-12

This step by step guide is generally applicable for almost every type of data file that you might encounter. A couple of the above windows might look different depending on the type of inputs files. For instance, with Excel files, you would encounter a window to select the tab in the sheet, which is to be imported.

It is our sincere hope that this post would help you to get started with your projects. Importing any data file is more than half the battle won when working on data analytics projects in the Audit Command Language.

Please keep practicing and feel free to reach out to us with your valuable feedback and comments. Please go to the website to review ACL script examples and ACL script commands sign up for our newsletter, so that we may keep you posted on the latest activity on our website and Youtube channel.