-
-
恩智浦凯文 初学数据Lv2
发表于2021-7-22 14:11
悬赏50
已解决
楼主
你好，表达式组件出现了问题。能帮我看一下有什么错误吗？
下面这条是我新增的表达式内容
if (Component_Part_Id = '17ASA00268D001' or Component_Part_Id = '17ASA00268D002' or Component_Part_Id = '17ASA00267D001' or Component_Part_Id = '17ASA00267D002' or Component_Part_Id = '17ASA00267D003' or Component_Part_Id = '17ASA00267D004' ) 'LQFP10HD'else if (Component_Part_Id = '17ASA00285D001' or Component_Part_Id = '17ASA00285D002' or Component_Part_Id = '17ASA00285D003' or Component_Part_Id = '17ASA00286D001' or Component_Part_Id = '17ASA00286D002' or Component_Part_Id = '17ASA00326D001' or Component_Part_Id = '17ASA00326D002' or Component_Part_Id = '17ASA00326D003' or Component_Part_Id = '17ASA00326D004' ) 'LQFP7HD'else if (Component_Part_Id = '17ASA00294D001' or Component_Part_Id = '17ASA00294D002' or Component_Part_Id = '17ASA00294D003' ) 'LQFP10EPHD'else Subgroup
Subgroup 来自主题表Leaded package，如下
下面这条是我新增的表达式内容
if (Component_Part_Id = '17ASA00268D001' or Component_Part_Id = '17ASA00268D002' or Component_Part_Id = '17ASA00267D001' or Component_Part_Id = '17ASA00267D002' or Component_Part_Id = '17ASA00267D003' or Component_Part_Id = '17ASA00267D004' ) 'LQFP10HD'else if (Component_Part_Id = '17ASA00285D001' or Component_Part_Id = '17ASA00285D002' or Component_Part_Id = '17ASA00285D003' or Component_Part_Id = '17ASA00286D001' or Component_Part_Id = '17ASA00286D002' or Component_Part_Id = '17ASA00326D001' or Component_Part_Id = '17ASA00326D002' or Component_Part_Id = '17ASA00326D003' or Component_Part_Id = '17ASA00326D004' ) 'LQFP7HD'else if (Component_Part_Id = '17ASA00294D001' or Component_Part_Id = '17ASA00294D002' or Component_Part_Id = '17ASA00294D003' ) 'LQFP10EPHD'else Subgroup
Subgroup 来自主题表Leaded package，如下
最近看过此主题的会员
3个回答
可以改成case when 的写法.注意in ['值1','值2'] 的括号 ,另外,表达式组件里面,获取字段.不是直接写字段名的.需要点击左边的字段名,带上前缀
果冻出场 发表于 2021-7-22 14:16
可以改成case when 的写法.注意in ['值1','值2'] 的括号 ,另外,表达式组件里面,获取字段.不是直接写字段名 ...
非常感谢！帮了我不少！ 你说的带上前缀指的是什么前缀？
