Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need to transpose the excel data into a normalized way

aparanjith1
8 - Asteroid

Hi all,

I am working on a excel sheet which needs to be transposed to a normalized way using alteryx tools, but I am unable to achieve that using the transpose and cross tab tools with in the Alteryx. Looking if someone can help me in this? 

 

Here are the sample images of my original excel sheet and the sheet which I need to convert into.

 

Original format of excel sheet:
Original Excel sheet.PNG

 

Sheet that needs to be converted into:

 

Sheet need to be converted.PNGt

The challenging part for me was to parse the Classified results and Raw results as a values into separate column "Results".

 

Can someone help me out in achieving this? Thanks in advance!

4 REPLIES 4
cmcclellan
14 - Magnetar

Can you please supply the XLS file ?  It saves time in typing it in again ( and maybe creating mistakes that don't exist )

aparanjith1
8 - Asteroid

Sure. Here it is.

cmcclellan
14 - Magnetar

This is how I would do it :

 

2018-12-07 21_17_21-Alteryx Designer x64 - transpose data.yxmd.png

aparanjith1
8 - Asteroid

That worked, thanks for the reply. Really appreciate it.

Labels
Top Solution Authors