Skip to content

Instantly share code, notes, and snippets.

@randyzwitch
Created November 7, 2019 17:43
Show Gist options
  • Save randyzwitch/82bdb1d818f568a88dbfb919399a7794 to your computer and use it in GitHub Desktop.
Save randyzwitch/82bdb1d818f568a88dbfb919399a7794 to your computer and use it in GitHub Desktop.
Insert into statement in OmnISci
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