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 am quite new to alteryx and any help will be much appreciated ,
I am attaching my given input and the desired output.
I used Cross tab in my workflow , to swap row data to column.
i realised its giving output in different lines. i wish to get the output for one category in single line.
There are two easy ways to do this.
First way is to Transpose and then Cross Tab back
Perhaps the easiest way is just to use a summarise tool and group by and then sum
Thank you so much , this worked perfectly fine.. but if i have some more columns name then how we need to modify the workflow.
I am attaching the input and output
All you need to do is to change the Key fields in the Transpose and Group By field in the Cross Tab