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 are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I have a data set in which am using a transpose tool to create a table and since it is generated from rows the columns can be some time less some time more, but i need to add a formula tool next to it . The issue am getting is when i add the column names next time if they are not there when data changes am getting errors. is there any easy way to solve this ?
If I understand your use case correctly, this solution should help you out. I'm also assuming that you meant to say that you used the cross tab tool since the Transpose tool takes columns and pivots to rows.
In the empty table text input tool, add fields that are needed in your formula tools.