kettle抽取数据问题

要通过kettle抽取sap得数据到库里再通过finereprot进行报表展示，遇到了个语句问题

如何将8000，8080，8060，9100，6000一起写进该语句内，则不需要重复创建表输入，谢谢

具体如图

sql语句如下：SELECT to_char(sysdate-1,'yyyymmdd') as WADAT_F,to_char(sysdate,'yyyymmdd') as WADAT_T,'8080' AS VKORG_F,'6000' AS VSTEL_F,'20' AS SPART_F,'' AS AUART_F FROM DUAL

希望大神可以帮忙解答下

1716639952 发布于 2020-10-28 09:30 （编辑于 2020-10-28 09:36）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：2 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共1回答

最佳回答

snrtuemcLv8专家互助
发布于2020-10-28 09:32（编辑于 2020-10-28 09:44）

设置参数，GC

"SELECT to_char(sysdate-1,'yyyymmdd') as WADAT_F,to_char(sysdate,'yyyymmdd') as WADAT_T,'8080' AS VKORG_F,'"+GC+"' AS VSTEL_F,'20' AS SPART_F,'' AS AUART_F FROM DUAL"

修改答案

SELECT to_char(sysdate-1,'yyyymmdd') as WADAT_F,to_char(sysdate,'yyyymmdd') as WADAT_T,'8080' AS VKORG_F,'6000' AS VSTEL_F,'20' AS SPART_F,'' AS AUART_F FROM DUAL

UNION ALL

SELECT to_char(sysdate-1,'yyyymmdd') as WADAT_F,to_char(sysdate,'yyyymmdd') as WADAT_T,'8060' AS VKORG_F,'6000' AS VSTEL_F,'20' AS SPART_F,'' AS AUART_F FROM DUAL

UNION ALL

SELECT to_char(sysdate-1,'yyyymmdd') as WADAT_F,to_char(sysdate,'yyyymmdd') as WADAT_T,'8000' AS VKORG_F,'6000' AS VSTEL_F,'20' AS SPART_F,'' AS AUART_F FROM DUAL

UNION ALL

SELECT to_char(sysdate-1,'yyyymmdd') as WADAT_F,to_char(sysdate,'yyyymmdd') as WADAT_T,'6000' AS VKORG_F,'6000' AS VSTEL_F,'20' AS SPART_F,'' AS AUART_F FROM DUAL

UNION ALL

SELECT to_char(sysdate-1,'yyyymmdd') as WADAT_F,to_char(sysdate,'yyyymmdd') as WADAT_T,'9100' AS VKORG_F,'6000' AS VSTEL_F,'20' AS SPART_F,'' AS AUART_F FROM DUAL