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 relatively new to Alteryx. I have two different data sets (Data #1 -2 columns and Data #2 -3 columns). I need to join the two and transpose the data to rows from columns. (Tools: transpose, join?) Thank you. Current File A States Amount CA $1 CO CT Current File B States Amount 1 Amount 2 CA $1 $5
Yes, I apologize for the cryptic post. I managed to join the two files and used the sum tool. After joining the two datasets, the result is 4 columns (Amounts 1-3) by 50 rows (states) and from here the transpose tool doesn't work so I must be missing something. I'm unable to attach anything right now.
Sounds like you need to transpose and select State as your Key Column. From there you will get a name value pair that you can then concatenate the values with the summarize tool. See example that I posted above.
Yes, the concatenate option is only available if the data type is set to string. Now that you have the name / value pair from the transpose tool, you should change the data type of value to a string and then you will be able to leverage the summarize tool in order to concatenate. Be sure to Group By state.