In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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
binu_acs
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

binu_acs
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

 

 

binu_acs
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