Audit Command Language – Scripts

Welcome to the latest post in the series ‘Audit Command Language Tutorial for Beginners’. At this point, it is our hope that you are able to successfully navigate the GUI of the ACL tool. If there are still any doubts, go through the video below for a walkthrough of the tool before reading on further.

In this post, we will be discussing how to set up and start scripting in your ACL projects. Audit Command Language scripts are fairly straightforward and easy to write as compared to other tools. In a backhanded fashion, on the simplicity also limits the functionality available in other tools in the market.

Creating a new script: Right click on the project folder in the ‘Project Navigator’ -> ‘New’ -> ‘Script’

script-1

Writing your first lines of script: Try writing the below script to create a new column ‘new_acct’ in the table ‘sample’.

OPEN SAMPLE

DELETE FIELD NEW_Gender OK
DEFINE FIELD NEW_Gender COMPUTED AS
ALLTRIM(Field_1)

After writing the script, press the ‘play’ button. If the script completes successfully, you would see the small green ‘check’ sign in the bottom right section of the tool.

If there is any error, there would a red dot next to the line with the error and a red cross at the bottom right corner of the tool. You may watch the video below for the same walk through.

Of course, there are a number of things that can be done via scripting in any tool and the same is true for Audit Command Language Scripts. Besides the creation of fields, there are functions (character, numeric, date), joins etc. and other commands for various other manipulations that can be performed on data sets. All these different aspects will be covered in separate posts so as to explore each in a detailed and comprehensively.

If you wish to be proactive in learning how to script in ACL, I would urge you to fiddle around with the ACL GUI. Any command that is performed using the GUI is logged in the logs. These can be check as each command is executed in the ‘log’ tab at the bottom of the project navigator. Select the command and the corresponding script would appear ‘Define’ window next to the project navigator. See image below.

These scripts can be used to build simple projects very quickly and allow for practice for beginners. So play around with the tool to learn and practice as much as you can for Audit Command Language Scripts.

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.

Audit Command Language – Workspaces

Welcome to ‘Audit Command Language Tutorial for Beginners’ series. Most seasoned analytics professionals often complain that there are better tools that ACL to perform analytics on data sets. In most scenarios, this is a fair complaint against the ACL tool. However, if there is one feature that sets ACL apart from others is the ‘Workspace’. The ‘Workspaces’ in ACL are kind of a short cut to scripting when required to create the new fields. Simply define the required fields in the ‘Workspace’, select the table and activate the ‘Work Space’. You can then simply add the new columns via scripting or the GUI.

Creating a Workspace

Simply right click in the ‘Project Navigator’ on the left of the program. Select New -> Workspace and rename the new Workspace appropriately.

work-space-step-1                   work-space-step-2

Scripting the Workspace

After creating the workspace, you need to write a script for the new column to be created in any existing table. Consider the sample script to create a new field ‘New_Gender’ from an existing field ‘Field_1’. The script in the work space would be

New_Gender                            Computed
alltrim(Field_1)

See below:

Activating the Workspace

Save the script in the workspace. Open the target table, right click on the workspace icon in the Project Navigator and click ‘Activate’. If you receive no pop-up, that implies the script in the workspace is correct and the new field is available to be added in the selected table. See image below

As you can see, the table ‘sample’ is selected the workspace is activated. Next, press ‘CTR + i’ to see the list of fields in the table. The newly created field would be present in that list.

To add a new column to the table using GUI, simply right-click on any column header in the table and select add column. Follow steps in the next windows and you’re done.

Going off the above example, imagine the possibilities of leveraging the same workspace to work on different tables. Essentially, the workspace is acting as complimentary scripts to the main scripts. It is for this reason, that in most script structures in ACL Audit Command Language, fields are not defined in the main body and certainly improves the performance of a project.