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

Possible Workaround for Fuzzy Join Across Two Files

Brian Element

Mon, 02/18/2019 - 20:17

Forums

Postings from the India IDEA data Analysis software users group

Hello Group Members,

Read more about Possible Workaround for Fuzzy Join Across Two Files
Log in or register to post comments

Duplicates ~ Non Duplicates ~ Unique Records

Brian Element

Mon, 02/18/2019 - 20:16

Forums

Postings from the India IDEA data Analysis software users group

Hello Group Members,

Let us look at simple methods to identify Duplicates, Non - Duplicates and Unique Records with an example in the post today.

Say you have a data file in IDEA with the fields TXN REF NO, CENTRE, DATE and AMOUNT.

The sample entry view looks like below ~

TXN REF NO, CENTRE, DATE, AMOUNT

1, DEL, 15.01.19, 500

2, MUM, 20.01.19, 7

Read more about Duplicates ~ Non Duplicates ~ Unique Records
Log in or register to post comments

File based Global Field Level Text Search in IDEA

Brian Element

Mon, 02/18/2019 - 20:16

Forums

Postings from the India IDEA data Analysis software users group

Hello Group Members,

We are familiar with the @ Function ~ @isini() which allows us to look for the presence of a Text occurrence in a defined field within IDEA.

Read more about File based Global Field Level Text Search in IDEA
Log in or register to post comments

Ratio Analysis - Inventory Turnover Ratio

Brian Element

Mon, 02/18/2019 - 20:15

Forums

Postings from the India IDEA data Analysis software users group

Hello Group Members,

IDEA lends immense value and ease to Ratio Analysis in Financial Statements and related accounts imported to IDEA.

Let us delve on this post with an example - the Inventory Turnover Ratio.

Read more about Ratio Analysis - Inventory Turnover Ratio
Log in or register to post comments

Managing Large Report Extractions from Business Application Systems

Brian Element

Sat, 02/02/2019 - 04:58

Forums

Postings from the India IDEA data Analysis software users group

Hello Group Members,

Read more about Managing Large Report Extractions from Business Application Systems
Log in or register to post comments

Capturing Transactions undertaken on Public Holidays

Brian Element

Fri, 02/01/2019 - 07:47

Forums

Postings from the India IDEA data Analysis software users group

Hello Group Members,

Read more about Capturing Transactions undertaken on Public Holidays
Log in or register to post comments

Converting Date Fields in Character Format to Date Format

Brian Element

Fri, 02/01/2019 - 07:47

Forums

Postings from the India IDEA data Analysis software users group

Hello Group Members,

Date fields in an IDEA database may appear within IDEA post import in Character format. This precludes Date based analytics since the field is in a Character format.

There are two ways we can convert the Date field in a Character format to a Date format.

One - Modify the existing field ~ change the field type from Character to Date and enter a suitable mask to mimic the Date.