Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

Alteryx Designer Desktop Discussions

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

Excel output manipulation

poornimak
7 - Meteor

My data is in below format:

 

General instructions:  
Column AColumn BColumn CColumn DColumn EColumn FColumn GColumn HColumn I
         
         

 

A1 has some text. Row 2 is where my columns are. I want my output in below format. If I use a select tool and uncheck Column A, my General instructions text will not be present in my output. Is there a way I can just remove column A data and get below output.

 

General instructions: 
Column BColumn CColumn DColumn EColumn FColumn GColumn HColumn I
        
        

 

Please let me know if there is a solution for this.

 

 

3 REPLIES 3
niklas_greilinger
10 - Fireball

Hello,
would this be a suitable solution for you? Workflow is attached.
poornimak.png

poornimak
7 - Meteor

Thank you @niklas_greilinger . This will work for me.

How can I process the same if I have multiple files to work with. My files are in .xlsx. 

niklas_greilinger
10 - Fireball

You can transform this workflow into a macro and process them one by one or within a batch macro. 

Labels
Top Solution Authors