Welcome to the latest post in the series of ‘Audit Command Language Tutorial for Beginners’. Before we discuss the tool in more detail, let us cover a few basic concepts in the next few posts. In this post, let us discuss data types.
There are many data types in the ACL just like any other tool. However, these can be covered in three main categories i.e. character (ASCII), numeric (Float, Numeric) and dates. See the ACL Help.
Also, check out the post on this site for the Audit Command Language Help.
Data types define the nature of the data in any specific column being imported into a table. For instance, a column such as ‘Order_Date’ would have date values, would be imported as ‘DateTime’. See Example
Data Import Screen in ACL
Similarly, while importing a numeric field, try to ensure that the maximum length is considered to avoid truncated values. Pay special attention to the decimal points for numeric values. Typical values for numeric data types would like ‘Sales’, ‘Units Sold’ etc. Similarly, watch out for columns with descriptive values like ‘Names’, ‘Store Name’, ‘Customer Name’ etc. for character values.
Avoid Data Issues
Very often, users rush to import data into an Audit Command Language project without carefully looking at the raw data. The below tips could be useful for avoiding such issues.
- Study the raw data files carefully to identify most data types.
- Make quick notes of the data structure and identify possible relations between data points.
- All data fields should be imported as character values from the raw data files. These values may be transformed to required formats during the execution of the Audit Command Language scripts.
For those interested in Audit Command Language certification, please refer to reference materials provided alongside the posts. These are helpful study materials to prepare for various certification exams. Also, please sign up for our newsletter to stay up to date with the latest activity on the site.