该功能可以将ETL中定义的数据处理以SPL脚本的形式保存到splx文件中,执行SPL脚本后,根据导出配置生成实际的数据文件。
在上面的ETL界面中点击工具 – 生成SPLX文件,然后保存为EmpForETL.splx,生成脚本内容如下:
|
A |
1 |
=connect("demo") |
2 |
="D:\\file\\ETL\\" |
3 |
=A1.query("SELECT Distinct GENDER FROM EMPLOYEE") |
4 |
=A3.(GENDER).new(#:gender_id,~:gender).keys@i(gender) |
5 |
=file(A2+"EMPLOYEE_GENDER.btx").export@b(A4) |
6 |
=file(A2+"department.txt").import@t(DEPT,MANAGER;," ") |
7 |
=A6.keys@i(DEPT) |
8 |
=file(A2+"department.btx").export@b(A6) |
9 |
=A1.cursor("SELECT EID,NAME,GENDER,BIRTHDAY,DEPT,SALARY FROM EMPLOYEE ") |
10 |
=A9.new(#@:id,EID,NAME,A4.pfind(GENDER):GENDER,BIRTHDAY,A7.pfind(DEPT):DEPT,SALARY,age(BIRTHDAY):AGE) |
11 |
=file(A2+"EMPLOYEE.ctx").create@yp(#id,EID,NAME,GENDER,BIRTHDAY,DEPT,SALARY,AGE).append(A10).close() |
12 |
=A1.close() |
在IDE中执行脚本后,D:/file/ETL目录下分别生成文件EMPLOYEE.ctx、EMPLOYEE_GENDER.btx、department.btx,文件内容分别如下:
EMPLOYEE.ctx:
EMPLOYEE_GENDER.btx:
department.btx: