Covid-19 time-series

Hi,

I'm working on a covid-19 time-series data with three csv files (confirmed, deaths and recovered worldwide)

I created a workflow in Alteryx which seemed to work fine, but on the recovered data on the last values just comes out as [NULL].

When I use the output file in Tableau the numbers for confirmed and deaths are correct, but recovered comes out wrong.

Does anyone know how to correct this?

I've attached the csv files and my alteryx file

Thanks!

Covid_workflow_3.yxmd

time_series_covid19_deaths_global_3011.csv

time_series_covid19_confirmed_global_3011.csv

time_series_covid19_recovered_global_3011.csv

Datasets

Accepted answers

philipmannering

Because Province is Null for Recovered, you have two options to include Canada. Either,

a) You make the province Null for Deaths and Confirmed

b) You keep province but forgo Recovered for Canada (you could join this on as well, but your numbers will be at an incorrect level of detail).

Both methods attached (and my edits in Turquoise). Hope this helps!

Phil

Covid_19_version6.yxmd

All comments

philipmannering

I think it's because your Confirmed and Deaths files have Canada broken down by province, but NOT for the Recovered file (therefore fewer records) and when you join on record position Nulls appear for Recovered. It's a bit risk joining on record position. I would recommend that you join on Country, Province and Name (Date).

Hope this explains the mystery.

Philip

hiom678

Thanks for your quick reply

I tried to do what you recommended, but then I get the error " String fields can only be joined to other string fields". Is it because I'm using "join multiple" and not "join". If I only use "join", then I can only connect the confirmed and deaths files, and then join "recovered" later..?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703