DataMagic Technical Column Vol.15

[Data tabulation section

Introduction

In many distribution industries, aggregation processes such as sales aggregation by store or by product attribute are frequently performed. Aggregation processes are also performed in a variety of industries and business processes, not just in the distribution industry, such as sales aggregation by sales department, aggregation of company-wide labor costs, and aggregation of labor costs by department. While these processes are relatively simple, such as calculating totals or averages, coding them individually often results in complex programming, and even simple aggregation processes require a significant amount of work, including error handling, log output, and program maintenance, not to mention evaluating the created programs.

With DataMagic, this type of aggregation process can be easily created and maintained.

This TIPS will introduce an example of how to aggregate salary data, including department codes, by department (total and average) and output the results to a file. Note that in order to use this TIPS, DataMagic must be installed on your computer. For information on where to obtain DataMagic and how to install it, please refer to the separate article "Installing DataMagic."

• DataMagic trial download
• DataMagic for Windows Installation
• DataMagic Manager Installation

How to operate

Step 1 - Prepare the source data

First, prepare the CSV data to be converted. Once the data is ready, save it in the following folder on the PC where DataMagic is installed.
C:\work\SAMPLE15\ (saved with the file name "in")

»Download the source data (Note: The sample file is in zip format. Please unzip it before use.)

Step 2 - Download and configure DataMagic script file

Download the script file below and save it in the folder where DataMagic is installed.
C:\work\SAMPLE15\ (saved as "sample15.igen")

Launch DataMagic management screen and import the downloaded script file into DataMagic. To import, click the [Import Management Information] icon under [Tools] on the start screen. Specify the downloaded file on the Import Management Information screen and click the Import button. The ID SAMPLE15 will then be registered on the Data Processing Information List screen.

»Download the script file (Note: The sample file is in zip format. Please unzip it before use.)

Step 3 - Run DataMagic

Double-click the data processing information ID SAMPLE15 registered in step 2 and check that the file names for the input and output settings are set correctly. Open the data processing information ID SAMPLE15 from the screen and click the "Execute" button at the top of the screen.

Step 4 - Check the execution results

When execution is complete in step 3, a file called "out" will be created in C:\work\SAMPLE15\, which is specified in the output settings. Check this file using an editor such as Notepad.

lastly

This time we performed aggregation using a single file, but it is also possible to aggregate data from multiple files and combine it with output distribution based on specific elements. By combining it with the functions introduced so far, even more advanced conversions can be easily achieved.
Please download DataMagic trial version and try out the technical column explanations.

• The trial version is free to use for 60 days.
• After you sign up for the trial version, you will receive 90 days of free technical support.

• DataMagic trial download

DataMagic Column List

Related Content