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