Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Turning Multiple Columns into one Column

Jtunner
Météore

Hi,

 

I have the following issue:

 

I have customers who buy goods.  But the data set list the columns as Customer Total Sales Coffee Tea Juice.  I would like to take the items and put them in one column and the amounts into another.  I have attached a before and after excel file.  Would love some help.  I know it is easy, but I am newbie who easily gets stumped!  Thank you!!!  JT

2 RÉPONSES 2
jasperlch
Quasar

Hi @Jtunner,

 

You have actually got the name of the tool required right. All you need is a Transpose tool, with "Name" checked as Key Fields, and "Coffee", "Tea", "Juice" checked as Data Fields in its Configurations. 

 

Thanks,

Jasper

Jtunner
Météore

Thank you!!!!!

Sondage
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Étiquettes