IDEAScripts

Zap ConsultingData analytics can test 100% of data to detect suspicious transactions for further investigation. Data analytics can also be used to examine, collate, and quantify transactions once an audit target area have been identified. GEL-1 is an example of an IDEAScript available on this website that can help to determine an audit target. Whistle-blowing and tips hotlines also provides high value areas to review and investigate. It is important for all organizations to have open communications and transparency with information that can be gathered to help narrow the search for the data analytical analyst.  One such service is Integrity Hotline™ (http://zapconsulting.ca/en-GB/integrityhotline) where they strive to provide organizations and their communities with a professional, anonymous, transparent, reporting mechanism to aid in the integrity of their business operations, detour financial frauds, while encouraging the organization’s community confidence and minimizing toxicity in the business environment. Integrity Hotline™ assists organizations in achieving positive corporate governance, with fairness, transparency and professionalism.

Unlimited Key eXtraction (UKX) with Selection

Background: 

This can be used to extract unlimited number of keys, with a facility to select/de-select keys as required.

Replicate DB

Background: 

Sometimes developers and script writers may want to use bigger datasets to test the duration of processing or to test how well the script handles bigger datasets. This script replicates the data to the required number of times.

Unlimited Key eXtraction (UKX)

Background: 

This script can be used to extract unlimited number of keys, which tries to address the limitation of IDEA wherein Key Value Extraction is possible only for the first 500 keys.

Extraction Based on Date

Background: 

A small script that allows you to do an extraction based on a date.

Generate Audit Number

Background: 

This script will create an number field that keeps a count based on the selected field.  When the contents of the field change it resets to 0 and starts the count over.  There is also a second script that will order the field based on a date field.

Split Text File

Background: 

This script will split a text file into smaller sections.

Date Creation Database

Background: 

This script will create a date database based on a start and end date.  The script can do all date or the beginning or end of the month.

Add Prefix-Suffix to Field Names

Background: 

This script will allow you to add a prefix or a suffix to all your field names.  This is great when performing a join or Visual Connector and don't want the entire file name to be included.

Add totals column

Background: 

This script will add a total field.  The total can be the running total on the entire file or it can be based on up to eight different key fields.

Append File Report

Background: 
This script will generate a report of the files you plan to append together to make sure there are no problems such as fields with the same name and different types.  This will look through all the files before you perform the append and generate a text report that you can review and make any corrections necessary.

Pages