当前位置：网站首页>Kettle experiment (III)

Kettle experiment (III)

2022-04-23 09:14:00 【Wind combed smoke】

1. Pass the data through what we have learned Excel Table method to import database

2. Put the data in KETTLE Row to column transfer （ The two methods ）

 

(1) stay kettle put Excel Table input component , And choose our data ” Transfer line column .xls”

 

 

 

(2) stay kettle Put the sort record component in the , Choose only date Sort fields in ascending order

 

(3) stay kettle Put the column to row component , The following settings

Be careful ：kettle There is a row to column component in , But there is no row to column component here , The specific reasons can be queried online  

(4) stay kettle Put the table output component in , Set the output destination as MySQL Database data database , Database table name ”hangzhuanlie”

 

 

(5) Use Navicat Tool return MySQL Check whether the database is successful

 

 

 

版权声明
本文为[Wind combed smoke]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230907157543.html

边栏推荐

猜你喜欢

随机推荐