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.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackFirst time participation in the challenge!!! Really excited 🙂
Thanks,
S.
looked for a better way to get the sort order correct but did not find anything clever so last step is sadly manual.
My solution in attach
Pretty easy, BUT:
The most difficult part of this workflow - which I have yet to tackle - is to automatically rename fields with a _ suffix to a % suffix. I want to do this because reshaping the data model using transpose/crosstab renames special characters with an underscore after remodelling... I think I could do it using a field info tool, union those parts and use a dynamic rename, but I think my workflow will suffice nontheless.
Not my most elegant, but it works.
My proposal