Hi Guys,
I have a table named TeamTrack, which contains a field named "DaysHandle"
That field contains several discrete values.
I need to associate the values in that field by categories, so I create the table "Categories" which contains the ranges (categories) I need, with a min and max for each range.
Now I intend to use IntervalMatch to associate the discrete values in field "DaysHandle" from table TeamTrack with the ranges (Categories) in table Categories.
It seems to be working, but I don't know how to show also the field DaysHandleCategory (it is dual, but I do not how to deal with it).
Thanks in advance,
Aldo.
TeamTrack20:
LOAD * INLINE [
DaysHandle, Field2, Field3
2, a, f
7, b, g
22, c, h
50, d, i
3, e, j
];
Categories:
Load
dual (CategoryName, MinValue) as DaysHandleCategory,
MinValue,
MaxValue
inline [
CategoryName, MinValue, MaxValue
'0-5', 0, 5
'6-20', 6, 20,
'21-40', 21, 40,
'40 and above', 41
];
intervalmatch(DaysHandle) load MinValue, MaxValue resident Categories;
drop table Categories;