Hi,
I have user data in a two column table that relates roles that users have in a enterprise database. They can choose up to 20 roles out of 150 or so roles. The table conceptually looks like the following (i apologize for the format):
User.....Role.. ..
John.....Role 1
John.....Role 45
Ron......Role 1
Ron......Role 25
Ron......Role 30
Shawn....Role 41
Shawn....Role 42
Shawn....Role 43
Shawn....Role 44
Shawn....Role 45
............... .
(Shawn continues up to Role 60)
............... .
Shawn....Role 60
I would like to create a table that creates 20 buckets that fill with each role that the person has.
User.....Bucket 1..Bucket 2..Bucket 3.......Bucket 20
John.....Role 1....Role 45
Ron......Role 1....Role 25...Role 30
Shawn....Role 41...Role 42...Role 43........Role 60
I know relationship-wise databases don't like this, but i have a good reason as to why i need to do this (at least i hope i do). any help would be greatly appreciated. A simple crosstab won't do because of the 150 or so headers and all the blank fields. i need to "bucketize" it like KFC...
Thanks,
Omar
I have user data in a two column table that relates roles that users have in a enterprise database. They can choose up to 20 roles out of 150 or so roles. The table conceptually looks like the following (i apologize for the format):
User.....Role.. ..
John.....Role 1
John.....Role 45
Ron......Role 1
Ron......Role 25
Ron......Role 30
Shawn....Role 41
Shawn....Role 42
Shawn....Role 43
Shawn....Role 44
Shawn....Role 45
............... .
(Shawn continues up to Role 60)
............... .
Shawn....Role 60
I would like to create a table that creates 20 buckets that fill with each role that the person has.
User.....Bucket 1..Bucket 2..Bucket 3.......Bucket 20
John.....Role 1....Role 45
Ron......Role 1....Role 25...Role 30
Shawn....Role 41...Role 42...Role 43........Role 60
I know relationship-wise databases don't like this, but i have a good reason as to why i need to do this (at least i hope i do). any help would be greatly appreciated. A simple crosstab won't do because of the 150 or so headers and all the blank fields. i need to "bucketize" it like KFC...
Thanks,
Omar
Comment