In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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