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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I have a data set where there are multiple rows for the same request number. Each row details provides a sequence step and time processed. I would like to combine all of the sequences and times processed into a single row (by request number). I've tried doing so by using the transpose/cross tab tool but it's not getting me anywhere. Any suggestions?
I am guessing that by keeping your Sequence ID in your Group By selections for the Cross Tab tool at the end of your original workflow, you might have been ending up listing them twice, when you're really capturing that info in the column headers and don't still want them listed out individually in your records below. Try adding this:
I agree with @NicoleJohnson, checking the Sequence ID in the "Group Data by these Values" in the Cross Tab is causing it to be split out to separate rows instead of keeping on a single row. You don't need to keep it checked as they are becoming your New Column Headers. Uncheck the Sequence ID in the Group Data by these Values.