I是此case条件表达式作为派生列,结果I不是预期的
(DT_STR,255,1252)((Step1_Emc_stg_Heading >= "315" && Step1_Emc_stg_Heading <= "45") ? "Northbound"
: (Step1_Emc_stg_Heading >= "46" && Step1_Emc_stg_Heading <= "135") ? "Eastbound"
: (Step1_Emc_stg_Heading >= "136" && Step1_Emc_stg_Heading <= "225") ? "Southbound"
: (Step1_Emc_stg_Heading >= "226" && Step1_Emc_stg_Heading <= "314") ? "Westbound" : "Nobound")
发布于 2018-05-30 08:49:07
我认为问题出在第一种情况。
Step1_Emc_stg_Heading >= "315" && Step1_Emc_stg_Heading <= "45"
您必须将45
替换为大于315
的数字,或者必须使用逻辑或||
或逻辑与&&
Step1_Emc_stg_Heading >= "315" || Step1_Emc_stg_Heading <= "45"
更新1
尝试以下表达式(使用数字而不是字符串,并重新排序条件):
(DT_STR,255,1252)((DT_I4)Step1_Emc_stg_Heading <= 45 ? "Northbound"
: (DT_I4)Step1_Emc_stg_Heading <= 135 ? "Eastbound"
: (DT_I4)Step1_Emc_stg_Heading <= 225 ? "Southbound"
: (DT_I4)Step1_Emc_stg_Heading <= 314 ? "Westbound"
: (DT_I4)Step1_Emc_stg_Heading >= 315 ? "Northbound" : "Nobound")
https://stackoverflow.com/questions/50594855
复制相似问题