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.

Formatting Issue

saachitalwar
8 - Asteroid

Hi

 

I have a table in the form 

 

NAMEAVERAGE WEIGHT% WEIGHT% CONTRIBAVERAGE WEIGHT% WEIGHT% CONTRIBWEIGHT DIFFOPTION SELECTSTATUS
          
          
          
          
          
          

 

how can I convert this into the below table

 

   TOP 10      
        
NAMEAVERAGE%%AVERAGE%%WEIGHTOPTION 
 WEIGHTWEIGHTCONTRIBWEIGHTWEIGHTCONTRIBDIFFSELECTSTATUS
          
          
          
          
          
          
          
          
          
1 REPLY 1
binuacs
21 - Polaris

@saachitalwar one way of doing this

image.png

Labels
Top Solution Authors