kettle文档 - 360文档中心

合集下载

相关主题

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

Kette

1 (2)

1.1 (2)

1.2 (3)

2 (3)

2.1 (3)

2.2) (4)

3 (5)

3. 1"Merge" (5)

3.2Sorted Merge (5)

3.3 (7)

3.4) (9)

4 (10)

4.1)split field to rows (10)

4.2) (11)

4.3 (12)

4.4 (12)

4.5 (13)

4.6) (14)

4.7 (14)

4.8 (15)

4.9) (16)

4.10) (17)

4.11)number range (18)

5flow (20)

5.1)switch/case (20)

5.2) (21)

6statistics (22)

6.1) (22)

7Uitlity (23)

7.1)If field value is null (23)

7.2)Null if... .. (25)

8 (26)

8.1)Check if a column exists (26)

8.2File exists (27)

8.3)Table exists (28)

8.4 (29)

8.5 (31)

8.6 (32)

9 (34)

9.1) Modified Java Script Value (34)

9.2)SQL (35)

9.3)Regex Evaluation (36)

1

11

"""1"

""""

""

1.2

""

"sql"

2

2.1

""

""""

"""" 2.2)

""kettle

""

"Specify datebase fileds"

"Datebase fileds""enter filed mapping"

add

guess

3

3. 1"Merge"

""""""

""

3.2Sorted Merge

null

1 2

""

3.3

1 2

3.4()

1

2

"" ""

4

4.1)split field to rows string

"Field to split "

"delimiter"--"new field name "

4.2)

"" ""

""

4.3(

)

""

4.41----n

""

4.5

""

name id

4.6)

""

"": 4.7

""

4.8

""

"value fieldname"

""""

""

4.9)

""

"a/b/c"

""

4.10)month112

1

""month

""

""month

"""1""2""3"1 4.11)number range

unkonw

""

"" ""

""

5flow

5.1)switch/case

"Field name name to switch"switch

""

""""id

""1 ""

5.2)

"" ""

6statistics

6.1)

""

"""""""subject" """"

7Uitlity

7.1)If field value is null

""

" "

""

(:""""1) 7.2)Null if...null

""null

""null 8

8.1)Check if a column exists

referer y n

""

8.2File exists,

""

8.3)Table exists y/n

""

""""

""

8.4

1

2

"""" ""

"1" """"

""

8.5

entp_list_id =47entp_list_id=411 Referrer =/6