From e6b40223e7559d6205bad62a6d22211042eeddec Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 6 Oct 2025 20:17:25 +0000 Subject: [PATCH] Note what solves conversion problem #38 --- conversion/load_data.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/conversion/load_data.sql b/conversion/load_data.sql index 91a5611..c60b33f 100644 --- a/conversion/load_data.sql +++ b/conversion/load_data.sql @@ -403,8 +403,8 @@ SELECT WHERE follows.focal = obs.fol_b_animid AND follows.date = obs.fol_date) , 'AM' -, COALESCE(obs.am_obs1, 'NONE') -, COALESCE(obs.am_obs2, 'NONE') +, COALESCE(obs.am_obs1, 'NONE') -- problem #38 +, COALESCE(obs.am_obs2, 'NONE') -- problem #38 FROM obs -- Don't try to load follows that haven't been converted JOIN follows ON (follows.focal = obs.fol_b_animid @@ -455,8 +455,8 @@ SELECT WHERE follows.focal = obs.fol_b_animid AND follows.date = obs.fol_date) , 'PM' -, COALESCE(obs.pm_obs1, 'NONE') -, COALESCE(obs.pm_obs2, 'NONE') +, COALESCE(obs.pm_obs1, 'NONE') -- problem #38 +, COALESCE(obs.pm_obs2, 'NONE') -- problem #38 FROM obs -- Don't try to load follows that haven't been converted JOIN follows ON (follows.focal = obs.fol_b_animid -- 2.34.1