Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Transformation

hjm35055
6 - Meteoroid

Hi,

 

Below you can see the current data that I have and what I need it to look like.  If I only had 3 "fruits" I think I could do this on my own the long way; however, I have 97 "fruits" and am wondering what the quickest way to do this is.  I was originally thinking the generate rows tool but am fairly new to Alteryx.  Thanks in advance for your help!!

 

Screen Shot 2017-04-07 at 3.19.25 PM.png

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

TRANSPOSE TOOL:

Key = Customer ID

Data = Select all fruits....

 

That one tool should be a favorite (favourite) for sure!

 

Cheers,

Mark

 

P.S.  After you transpose it, you could filter by Value > 0 and the use a Select to drop the value column

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
hjm35055
6 - Meteoroid

Thank you!!!!!

Labels