Skip to content

Instantly share code, notes, and snippets.

@rjriel
Created May 28, 2019 14:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rjriel/c353ddec94396b3f50b0b8c4a63d847a to your computer and use it in GitHub Desktop.
Save rjriel/c353ddec94396b3f50b0b8c4a63d847a to your computer and use it in GitHub Desktop.
Simulator:
LOAD
*
FROM [lib://data/processed/ski-data.csv]
(txt, utf8, embedded labels, delimiter is ',');
Simulator:
ADD LOAD
[Race ID],
Badge,
Course,
[Gates Total],
[Race Status],
Time,
Speed,
[Gates Passed],
Errors,
[Edging Left],
[Edging Right],
[Gate Edging Left],
[Gate Edging Right],
[GeoPos N],
[GeoPos E],
[GeoPos H],
[Time Recorded]
FROM [lib://data/unprocessed/ski-data.csv]
(txt, utf8, embedded labels, delimiter is ',')
WHERE NOT EXISTS ([Time Recorded]);
Badges:
LOAD
*
FROM [lib://data/processed/badges.csv]
(txt, utf8, embedded labels, delimiter is ',');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment