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.
I'm new to Alteryx so bear with me. I have lots of fields on the format name (monthyear), e.g. "january2019", "february2019", "march2019" etc. What I have done so far is to load the data by using the Asterix symbol (since all excel files contains the month and year), then check for output file name as field, used the text to columns tool appropriately and finally the cross tab tool. However, the fields are not sorted according to the correct dates. As an example, "february2019" appears before (i.e. to the left for) "january2019". I know that you can use the select tool and move fields up/down, but is there a smarter way to tell alteryx to sort the fields with dates according to my fields' name format? In this case there were not that many fields, but let's say there were 100+ fields, then it would be expedient if I could tell Alteryx to sort them by using some kind of tool.
I would sort your dates in their column (before the cross tab) and rename them so january2019 -> 1_january2019 and february -> 2_february2019. Then once you've crosstabbed you can remove the number and underscore using regex or a trim, etc. Example attached,