Connecting raw data from CSV files

wave_wstn

Hi Alteryx, 

I am working on a project and I need some help. So, I downloaded raw data from yahoo finance, and I want to make comparisons of the top ten cryptocurrencies from the last year. I was able to input all of the data, but now I do not know how to connect it so I can analyze them all together and make comparisons. What should I do first?

Luke_C

Hi @wave_wstn 

The first thing you can do is read-in all the csv files together in one input tool. Assuming they're all in the same folder (and no non-related csv files are present) you can do something like this by putting *.csv in the input tool. It will look for any csv files in that folder and input them all together (assuming the columns are the same). You'll also want to input the file name as a column so you can differentiate the data for the different cryptos

I know you're just learning Alteryx, but just to demonstrate a little more advanced capability of the tool, you could remove the need to even download the csv files, and just use the download tool!

I attached a workflow that does the following:

Container 1:

1. Creates the yahoo finance download URL based on a list of cryptocurrency tickers
2. downloads the data
3. parses it into one table using the text to columns tools, dynamic rename, data cleansing, etc

Container 2:

1. I calculated the daily % change based on the open/close prices
2. Then sorted and chose the first and last 10 records
3. combined (unioned) those sets to show the biggest swings in any one token's price

New Workflow2.yxmd