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.
Hi,
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.
Help is much appreciated!
Regards, PC
I am attempting to apply the same logic to my model but when I use the dynamic rename, it changes my columns headers to _field. Any thoughts on why this is happening?