how to output same column from multiple files

Question

Hi all，

I'm doing an analysis of covid19 daily data in Alteryx, but I found that the data published by CSSEGISandData on github has more than 300 files, some of which have morbidity and fatality rates, some of them don’t, how can I get more than 300 Each file has morbidity and mortality rates, and the original data type must be changed to percentage. And how can I join GDP files with these more than 300 files? Thanks a lot!

I attached my workflow and GDP file below.

Covid-19  Workflow 1.yxmc

Covid-19  Workflow 2.yxmc

Quarterly GDP.csv

echuong1 · Accepted Answer

You can create a batch macro that will de-select all fields except for the value field, and change the data type to a numeric one. The parameter for the batch macro would be the full path of each file, to update the input tool with each run.

In the actual workflow, you'd have a directory tool pointing to a folder with all of the files. You would use the full path field as the parameter for the macro.

See attached for example. Hope this helps!