-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major
-
Affects Version/s: V4.0_CS02
-
Component/s: Data Aggregation
-
None
-
Environment:
Applied
The four-step algorithm given at the beginning of the groupby transformation does not describe what happens for Products?$apply=groupby((Category)). According to a later remark, this is supposed to select only the distinct Categories. But, after step 1, I have two subsets
| ID | Category | Name | Color | TaxRate |
|---|---|---|---|---|
| P1 | PG1 | Sugar | White | 0.06 |
| P2 | PG1 | Coffee | Brown | 0.06 |
and
| ID | Category | Name | Color | TaxRate |
|---|---|---|---|---|
| P3 | PG2 | Paper | White | 0.14 |
| P4 | PG2 | Pencil | Black | 0.14 |
Step 2 cannot be carried out due to lack of a second parameter. Step 3 has no effect. Step 4 concatenates these two subsets again, so that the overall effect is of groupby((Category),identity).
To keep the case without second parameter within the four-step framework, step 2 must essentially produce an instance without properties, leading to subsets
| ID | Category | Name | Color | TaxRate |
|---|---|---|---|---|
and
| ID | Category | Name | Color | TaxRate |
|---|---|---|---|---|
which step 3 would then change to
| ID | Category | Name | Color | TaxRate |
|---|---|---|---|---|
| PG1 |
and
| ID | Category | Name | Color | TaxRate |
|---|---|---|---|---|
| PG2 |