1.新建数据库连接
注:需填写数据库IP、数据库、端口、账户和密码,其余内容可自定义。
2.新建转换
a.Table input 内容
select 1 as sort_num, DATE_FORMAT(DATE_SUB(now(),INTERVAL 0 day),'%Y-%m-%d') as data_date
union
select 2 as sort_num, DATE_FORMAT(DATE_SUB(now(),INTERVAL 0 day),'%Y-%m-%d') as data_date
union
select 3 as sort_num, DATE_FORMAT(DATE_SUB(now(),INTERVAL 0 day),