Postings from the India IDEA data Analysis software users group

Description

This forum will contian tips from the India IDEA Data Analysis Software Users Group. If you are interested in joining them you can find them on google groups at http://groups.google.com/group/idea-data-analysis-software-users---india

Editing the Criteria behind Virtual Fields

Brian Element

Forums

Hello Group Members,
 
We often need to append Virtual Fields to an IDEA database to perform a calculation, to prove a calculation or to sanitise/convert field type of native data within IDEA to make the data ready for further analysis thereby meeting our end analysis objective. An example - a master file has the field “Name” where you have two sample names in the database within IDEA as “Mr. Eric Brown - London” and the same name appearing in another row as “Eric brown” only.

Multistate Fields in IDEA and Legends against these Fields in MS-Excel

Brian Element

Forums

Hello Group Members,
 
As an IDEA User you can append ‘Multistate Fields’ to any database in IDEA. ‘Multistate Fields’ allow users to place specific tags like check marks, cross marks, question marks or blanks against each line item in a database of potential findings generated out of any feature in IDEA. By a single click inside any cell against a line item the user can change the tag from a click to a cross to a question mark and a blank.

Duplicates across Rows Vs Duplicates across Columns

Brian Element

Forums

Hello Group Members,
 
We are familiar with the Duplicate Key feature in IDEA which has been covered in the Back to Basics post of last week.
 
The Duplicate Key feature is best used while seeking out Duplicate fields in a database where the fields to match may be one or a combination of fields up to and including eight. Here the values to be matched are across rows in the IDEA Data file.
Subscribe to Postings from the India IDEA data Analysis software users group