Please see attached. I currently have this output summarized by all the applicable fields you see.
The first two are duplicate (teacher ID and date) for multiple rows: I am trying to determine which resources are commonly requested together and so my output thus far has resulted in multiple rows per teacher, date.
What I would like to do is take the 2-5 rows per teacher/date and concatenate the resource category into a single record/row by teacher ID/date (i.e. Supplies, Technology) vs Supplies in one row and Technology in the next row.
I tried using a Crosstab tool without success, but maybe I'm just missing something.
Appreciate the help!
Solved! Go to Solution.
I've offered @JGalle0121 a private webex session if he/she is available to review their challenge. In looking at the data, there is more than meets the eye in the requirements.
Cheers,
Mark
Thanks @BenMoss! This worked perfectly, I added some additional functionality as well to get common concatenations across the board. I've given you a star for feedback, appreciate the assist.
@MarqueeCrew Thanks for offering to WebEx, that's extremely generous of you. I've given you a star for feedback as well :)
Thanks for the star :)
I think that you will also find that your combination of resources will be a challenge. There are examples where the resources for a given teacher/date combination include duplicates of the resource (e.g. Books, Books, Supplies). I don't know how you want to handle these occurrences, but think that you might want to use a UNIQUE tool prior to the summarize tool where you group by teacher, date, resource.
Cheers,
Mark