Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution to the Mushroom Challenge:
Neat challenge
The task is seemingly pretty straight forward however two observations.
1) I wanted to make the no. of columns dynamic for safe guarding (and fun).
2) When you Cross Tab you automatically sort field order alphabetically. I first thought was to filter out first row and join as header and then Cross Tab, but that will also implicitly order column names.
Ipso facto I ended up with this bad boy of a workflow. And yes, I left the cache on to brag about this new cool feature. saved me many seconds :P