kettle如何实现列转行

本文主要记录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文件内容