We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Downloading Multiple csv From URL

NOLA_Max
6 - Meteoroid

The below workflow works fine with a single csv, but I can't figure out how to make it work with multiple URLs/csv. Any help is much appreciated.

6 REPLIES 6
binuacs
21 - Polaris

@NOLA_Max Seems to be your workflow downloading all the 3 given csv's. Are you expecting a different result?

 

binuacs_0-1678997392878.png

 

NOLA_Max
6 - Meteoroid

@binuacs, I am only seeing output for the first url: 

Download.JPG

binuacs
21 - Polaris

@NOLA_Max See the record count of each files, since you unselected the URL from the select tool, it would be difficult to identify the records from which file . Connect a summarise tool and configure like below and check the counts individually

 

binuacs_2-1678998121305.png

 

 

NOLA_Max
6 - Meteoroid

@binuacs, each of the 3 urls/csv has 2 columns so I am wanting to get to 6 output columns as shown below. What is happening is they are being stacked on top of one another into just 2 columns (the image above), which I figured out from your tip. 

 

When I run the workflow with one url at a time I get the expected (desired) columns:

 

ref.JPG

indicator.JPG

source.JPG

 

 

binuacs
21 - Polaris

@NOLA_Max You can output the result into an excel with three different tabs, let me know that works for you

 

binuacs_0-1679000704700.png

 

NOLA_Max
6 - Meteoroid

@binuacs, yes I am able to work with this. Thank you.

Labels
Top Solution Authors