how to output same column from multiple files

[Myra01]

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.

[echuong1 · Accepted solution]

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!

[Myra01]

Hi,

Thank you for your reply, but I don't really get the first point then, do you mean I should combine both of these workflows that i uploaded via batch macro?