回答：转换一下，比如数值格式是 3.8（小时）oracle：select ceil(3.8)||'小时'||(3.8-trunc(3.8))*60||'分钟' from dual帆软公式：trunc(3.8)+'小时'+(3.8-trunc(3.8))*60+'分钟'

回答：先按 month week day 排序， 然后 act plan goal 排序 出来就是正常的顺序啊with x as(select 'M' as c_date,'A' as c_type,100 as je from dualunion allselect 'M' as c_date,'B' as c_type,30 as je from dualunion allselect 'M' as c_date,'C' as c_type,70 as je from dualunion allselect 'W' as c_date,'A' as c_type,100 as je from dualunion allselect 'W' as c_date,'B' as c_type,30 as je from dualunion allselect 'W' as c_date,'C' as c_type,70 as je from dualunion allselect 'D' as c_date,'B' as c_type,30 as je from dualunion allselect 'D' as c_date,'C' as c_type,70 as je from dual) selecT *  from x order by case when c_date='M' then '01'when c_date='W' then '02'when c_date='D' then '03' end,case when c_type='A' then '01'when c_type='B' then '02'when c_type='C' then '03' end

回答：可以试下这个插件，装完之后可以选择按显示值还是实际值导入，实际值的excel有几位小数就导几位

回答：对应分类有空的值把

回答：1，将三个单元格的内容合并到一个单元格E2内2，然后count本单元格E2内容在整列中出现的次数  count(E2{E2 = $E2})3，加数据校验count值=1,不等于1的行报错重复

回答：在单元格里过滤就可以了，两边都加上对方的关联字段，就是inner join

回答：建议另做一个模板，在数据集里只筛选出需要发送邮件的内容，用于定时任务用

回答：要么把控件格式改成年月日，要么把实际时间格式转换成年月呗

回答：表输入组件点预览不会报错一版都能进表输出看不到你的sql，只能猜测是不是用了 union all ，两边的类型可能不同

回答：人才利润表.zip这个demo直接有模板啊