โ04-10-2020 12:00 AM
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)
โ04-10-2020 06:38 PM
The SnapLogic Blog post is forthcoming, but you can see the content now on Medium.
โ04-11-2020 11:13 PM
โ04-19-2021 01:47 PM
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"})