Transform and Visualize COVID-19 Data

[ptaylor]

This sample pipeline is explained in detail by a SnapLogic Blog post to appear shortly.

COVID-19 Example_2020_04_08.slp (12.8 KB)

[ptaylor]

The SnapLogic Blog post is forthcoming, but you can see the content now on Medium.

[ptaylor]

SnapLogic – 10 Apr 20

Transforming and Visualizing COVID-19 Data

In this blog, I will walk through the construction of a SnapLogic pipeline, which transforms and helps visualize COVID-19 data.

[ptaylor]

Here’s an updated pipeline to fix an issue related to sorting by date. For example, after sorting, “10/1/20” should be after “9/30/20” but was before it.
COVID-19 Example_2021_04_15.slp (14.4 KB)

In this version, I’ve inserted a new Mapper to reformat the dates so that they sort correctly:

Here’s the expression as text:
Date.parse($Date,"MM/dd/yy").toLocaleDateString({"format":"yyyy/MM/dd"})