<< Click to Display Table of Contents >>
Horizontal division
Divide a group dataset in a group data store into multiple datasets horizontally.
Horizontal division produces multiple independent datasets from one dataset. master/detail relationship. Original dataset is divided into master group dataset, detail dataset and detail group dataset.
Lets take an example of the original dataset:
ProductCode |
ProductName |
UnitPrice |
A |
FLAT TV 19" |
500,000 |
A |
FLAT TV 21" |
800,000 |
A |
FLAT TV 25" |
1,500,000 |
B |
wide tire |
100,000 |
B |
wide tire V |
180,000 |
C |
apple flavor drink |
500 |
C |
grape flavor drink |
500 |
To make tables by ProductCode, divide the original dataset horizontally.
•<A Set> (condition) #Original_Set.ProductCode# == "A"
ProductCode |
ProductName |
UnitPrice |
A |
FLAT TV 19" |
500,000 |
A |
FLAT TV 21" |
800,000 |
A |
FLAT TV 25" |
1,500,000 |
•<B Set> (condition) #Original_Set.ProductCode# == "B"
ProductCode |
ProductName |
UnitPrice |
B |
wide tire |
100,000 |
B |
wide tire V |
180,000 |
•<C Set> (condition) #Original_Set.ProductCode# == "C"
ProductCode |
ProductName |
UnitPrice |
C |
apple flavor drink |
500 |
C |
grape flavor drink |
500 |
Note
Vertical division and horizontal division can be used together.