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.
While this is indeed a simple solution and I will be implementing this, could you please help me with an alternate solution using the dynamic select tool, too? It will be an important learning point as I often run into cases where I have to dynamically select columns and pass to several tools such as the XML Parse, or the Text to Columns, etc. Currently, I hard code the column names which I feel is not very efficient and robust.
To dynamically rename a column name, you would use the DYNAMIC RENAME tool. If you want to replace all underscore characters with a space, I would use a formula like:
To dynamically setup a Max(column name) value in the summarize tool, I would still use the approach of using a TRANSPOSE tool. There is a data investigation tool, Field Summary which will provide metrics on your input data and will provide you with the maximum value of every column.
Once you rename the fields and run the field summary, maybe this is all that you need.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.