Created
November 7, 2019 17:43
-
-
Save randyzwitch/82bdb1d818f568a88dbfb919399a7794 to your computer and use it in GitHub Desktop.
Insert into statement in OmnISci
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
insert into baywheels_tripdata | |
select | |
duration_sec, | |
start_time, | |
end_time, | |
start_station_id, | |
start_station_name, | |
start_station_latitude, | |
start_station_longitude, | |
end_station_id, | |
end_station_name, | |
end_station_latitude, | |
end_station_longitude, | |
bike_id, | |
user_type, | |
member_birth_year, | |
member_gender, | |
case | |
when bike_share_for_all_trip is not null then bike_share_for_all_trip | |
when extracol = 'app' then 'No' | |
when extracol = 'clipper' then 'Yes' | |
end as bike_share_for_all_trip | |
from baywheels_tripdata_extracol; | |
--drop table with extracol, since it's been corrected and loaded into main table | |
drop table baywheels_tripdata_extracol; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment