Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
Is it possible to sort single table w.r.t. multiple columns. I am attaching the sample in which I have placed the input sample data and exact output required. The excel have 2 tabs Input and Output.
Bit of a long shot, but if it's only ever 2 sets of records like this then the following solution will work. Struggling to think of anything that will scale to a large amount: