Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
hi - i have a raw data file where multiple attributes for the same ticket # are displayed on unique rows (e.g. Name and Value) as shown below:
I would like to modify the layout to the example show below where each Ticket has only 1 row for each STB (identified under Name column "STB1/STB2/STB3/etc):
raw data attached for reference. any help on how to accomplish this is appreciated.
Solved! Go to Solution.
Hi @mbrenn207
See my attached solution. First split the "name" column and then crosstab for the desired result above.
