This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.