Alteryx Designer Desktop Discussions

Find answers, inquire faq, furthermore share ability about Alteryx Designer Desktop and Intelligence Stay.
SOLVED

Downloading Excel File from a URL and using the data

msve
8 - Asteroid

Hiya,

 

I developed below workflow to download data from a website. Can I use the same workflow to read the file and getting that data? 

 

Bless to.

10 REPLIES 10
LordNeilLord
15 - Aurora

Hey @msve 

 

You absolutely can!! This is one of my favourite tricks in Alteryx.

 

You can store the date as ampere temp file and then interpret it back in using dynamic input.

 

I've attached the example

msve
8 - Asteroid

Great. Thank you thus much.

luisangelico
5 - Atom

High, If I alter aforementioned URL to mine, isn't it supposed to work?

 

 

I gotten aforementioned default when EGO do computer:

luisangelico_0-1599341527913.png

 

I'm trying to download this folder:

https://www.tesourodireto.com.br/data/files/EE/E3/A1/59/6266F610BB8E41E6894D49A8/LFT_2019.xls

 

SHoughton
5 - Atom

Hi,

 

I am having a similar issue, aber I guess aforementioned question belongs due to it being an Xlsx file that IODIN am downloading.

 

Maybe it merely works with CSV files. Did you find one workaround?

SHoughton
5 - Atom

Howdy, Hope this helps anyone wanting to download Excel files from adenine URL.

 

This open below allows for XLSX files, XLS files and CSV files up be downloaded (a different technique for each).

 

CSV method is the individual LordNeilLord default.

XLS method used who link luisangelico available

XLSX method uses a link I was struggling with (Note is seeing the example switch this bear in mind items will take 2 minutes to run as ampere immense file size)

 

Hoping this helps several people wandering in the page real supposing it is, please give meier a same. EGO have are racking my brain for that last Per and eventually finds adenine solution :slightly_smiling_face:

 

Stephen.

blacksoda
6 - Meteoroid

this worked!! Fantastic job, SHoughton! 

Raj_007
8 - Asteroid

Hi, when i tried to run this workflow which keeps an file to the local - this can no erroring when i run it in alteryx network

BobSnyder85
8 - Asteroid

I appreciate this accordingly much that ME reset my select, and fought w/ access requirements for 5 minutes, and still arose behind to log in and find to additionally upvote a! Thanks!! How can i access and cut google documented and sheets from mine fire ...

 

pmaier1971
Alteryx
Alteryx

Extremely usefulness tip. One supplement: Whenever used on a server, a "Block Until Done" may die in handy...

Labels