kettle 列转行实际应用场景demo！！！

本文主要记录kettle列转行控件的使用。

1、用例脚本

create TABLE studentInfo
(
studentno int,
Cname varchar(10),
grade int
);
insert into studentInfo values(2018100,‘语文’,81);
insert into studentInfo values(2018100,‘数学’,82);
insert into studentInfo values(2018100,‘英语’,83);

insert into studentInfo values(2018101,‘语文’,71);
insert into studentInfo values(2018101,‘数学’,71);
insert into studentInfo values(2018101,‘英语’,72);

insert into studentInfo values(2018102,‘语文’,91);
insert into studentInfo values(2018102,‘数学’,92);
insert into studentInfo values(2018102,‘英语’,93);

INSERT INTO studentInfo VALUES(2018103,‘语文’,60);
INSERT INTO studentInfo VALUES(2018103,‘数学’,61);
INSERT INTO studentInfo VALUES(2018103,‘英语’,94);
commit;

ktr文件如下所示：

表输入

SELECT studentno,Cname,grade FROM studentInfo order by studentno

列转行

字段选择

excel文件输出

运行后，excel文件内容

作者：huangyongwen2009
来源：CSDN
原文：https://blog.csdn.net/huangyongwen2009/article/details/79745796
版权声明：本文为博主原创文章，转载请附上博文链接！