Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Process to parse out Excel Spreadsheet

Estela_Jimenez
5 - Atom

Hello,

 

I have spreadsheet in excel I use on a regular basis for a workflow.  The current process requires us to manually fix, delete, adjust, add rows and columns.  I would like to see if there is a way(s) in Alteryx to automate this repetitive task.  I have tried several workflows but I seem to run into always having to edit the file first and I would like to have the process fully automated in Alteryx...meaning I download the file and place it in the workflow to process.  I attached a copy of the file I download(Sample Spreadsheet.xlsx) and the desired output(Sample_Spreadsheet_needs_To_Be.xlsx).

 

Any help is appreciated!

2 REPLIES 2
ArtApa
Alteryx
Alteryx

Hi @Estela_Jimenez - I designed a workflow for you:

ArtApa_0-1623978471300.png

 

Estela_Jimenez
5 - Atom

Hi @ArtApa,

 

This is incredible!  Thank you so much!  It worked.

 

Thanks,

Estela

Labels
Top Solution Authors