Initial State
Practice Exercise 1
Find the five employees with the highest number of transactions in the Southern region and remove the "Tenure", "Income" and "Total_Compensation" columns.
An Input Data tool contains 100 records, each representing a unique employee's transaction information. The Emp ID (a unique identifier for each employee) and Business Area provide basic information about the employee. The transactions column represents the average number of payroll deduction transactions that employee has made over the past year.
In this exercise, drop the columns "Tenure", "Income", and "Total_Compensation". Then find the 5 employees with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.
Final State
Start 1.yxdb
Start 1.yxdb
Final State - Exercise 1.yxdb
Final State - Exercise 1.yxdb
Simple
=
Region
True
fixed
2020-06-15 15:01:47
0
South
2020-06-15 15:01:47
2020-06-15 15:01:47
[Region] = "South"
C:\Users\eriong02\AppData\Local\Temp\Engine_9964_aca1fbbb47cf4061b4d4dfecb163bfb1_\Engine_9904_b871603fbc2d47b4b17702a6563ba666_.yxdb
Single
Profile
TransInYear - Descending
First
5
First 5
C:\Users\eriong02\AppData\Local\Temp\Engine_9964_aca1fbbb47cf4061b4d4dfecb163bfb1_\Engine_9904_cfb0fb8d69ea4f32a10b9380c9eb8b62_.yxdb
Single
Profile
Horizontal
Practice Exercise 1