Is it possible to sort at a row level? The current tab shows how my data is structured, the need tab is my solution. Is this possible to do a row level sort starting with Teacher1 through Teacher10 in Alteryx?
Current:
Student | Teacher 1 | Teacher 2 | Teacher 3 | Teacher 4 | Teacher 5 | Teacher 6 | Teacher 7 | Teacher 8 | Teacher 9 | Teacher 10 |
Bob | AMANDA | MINDY | PATRICK | MICHAEL | PAUL | ALISON | MILA | CHRISTOPHE | STEPHEN | MADELYN |
Bill | CELESTINA | ERIC | BROOKE | AYOTUNDE | ANDREA | JONATHAN | AIDAN | AUREA | ALBANETTE | STEPHEN |
Erick | KEVIN | MCGWIRE | JOHNELL | JOSEPH | ALEXA | GARY | BRICE | DEENA | DOUGLAS | MONIQUE |
Tyrion | ELIZABETH | JASON | SHUBIN | CHRISTOPHE | KYLE | RICHARD | JAMES | JEFFREY | RICHARD | IVAN |
Cersei | HANA | PHILIP | BIBBY | CHARLES | KIMBERLY | DAVID | DAVID | RAGHAVENDRA | AMBER | MARGERY |
Jaime | KATHY | EMMY | MARGARET | BRIAN | MICHAEL | CAROLE | RAYMOND | GLENN | ELISE | FRANCES |
Need:
Student | Teacher 1 | Teacher 2 | Teacher 3 | Teacher 4 | Teacher 5 | Teacher 6 | Teacher 7 | Teacher 8 | Teacher 9 | Teacher 10 |
Bob | ALISON | AMANDA | CHRISTOPHE | MADELYN | MICHAEL | MILA | MINDY | PATRICK | PAUL | STEPHEN |
Bill | AIDAN | ALBANETTE | ANDREA | AUREA | AYOTUNDE | BROOKE | CELESTINA | ERIC | JONATHAN | STEPHEN |
Erick | ALEXA | BRICE | DEENA | DOUGLAS | GARY | JOHNELL | JOSEPH | KEVIN | MCGWIRE | MONIQUE |
Tyrion | CHRISTOPHE | ELIZABETH | IVAN | JAMES | JASON | JEFFREY | KYLE | RICHARD | RICHARD | SHUBIN |
Cersei | AMBER | BIBBY | CHARLES | DAVID | DAVID | HANA | KIMBERLY | MARGERY | PHILIP | RAGHAVENDRA |
Jaime | BRIAN | CAROLE | ELISE | EMMY | FRANCES | GLENN | KATHY | MARGARET | MICHAEL | RAYMOND |
Solved! Go to Solution.
The Sort tool will do the trick (example attached)
That's a really nice solution to this -- I'm going to file this away for future reference. The one thing I noticed is that if the teacher names are duplicated then the duplications are excluded. May I suggest a small modification to include these dupes? Rather than grouping by Value, concatenate instead and then parse into rows to keep the duplicates --
did my second post come through? For some reason I was unable to post a workflow responding to ponraj's response, so I added a response to the OP - let me know if it isn't visible on your end.
@myastarling yes. It showed right after I asked to share your workflow. Thanks @ponraj and @myastarling for the solution!
whoops! my apologies! it needs one more sort tool immediately after the Transpose tool (sort by Value - ascending) - otherwise it reassembles everything back into the original order.