Download Tool usage

Hi Everyone,

I have one link by pasting it over chrome it downloaded the file directly. So, need your help how to configure that link so i could download that file in alteryx itself and transform it.

Link :- https://sample-videos.com/csv/Sample-Spreadsheet-1000-rows.csv

Can anyone help me create the workflow routine or direct me how to use it in alteryx.

Thanks

Workflow

Developer

Input

Best Practices

Batch Macro

Help

Dynamic Processing

Data Investigation

Accepted answers

All comments

Luke_C

Hi @atulggrwl2

Take a look at the attached. The URL is passed into the download tool, then I use the text to columns tools to split the data into rows, as well as split the data into columns. It doesn't look like column headers are included though.

New Workflow15.yxmd

mceleavey

Hi @atulggrwl2 ,

I've attached the workflow for you.

It's worth looking into the parsing tools.

Hope this helps.

download example.yxmd

Maskell_Rascal

Hey @atulggrwl2

Here is an approach that downloads the file as a temporary file, passes that file path onto the Python Tool, and the a small python script reads in the data for you.

I've attached a sample workflow for you to try.

Thanks!

Phil

Download and Extract CSV File.yxmd

apathetichell

Since @Maskell_Rascal posted his Python version - I've included an R version. Note - requires you to download the readr package. Note 2- gives you the column headings so it's 999 row - unlike the Python version...

r csv reader.yxmd

atulggrwl2

Thankw for your solution this is the dummy site i have given it to you for download but in acual scenario it is not able to give me any output.

We have some site need login id and password so like if we already signed in google chrome and paste that link that we are able to download

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703