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

Kettle experiment

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

Analyze the generated data , What needs to be dealt with is ：

（1） Set the registration date and time String, Because we can't extract the date directly from the preset format , Need to take string truncation ; （2） String truncation of date and ID card , Extract the code of day and province respectively （ Top two of ID card ）;

（3） Sort by fields to be grouped ;

（4） Value mapping for provinces and time periods ;

（4） Group statistics .

1. Formal experiment

stay “Excel Input ” Components , Set as follows ：

 

stay “ Field selection ” Components , Set as follows ： 

 

stay “ Cut string ” Components , Set as follows ：

 

stay “ sort record ” Components , Set as follows ：

stay “ Value mapping ” Components , Set as follows ： See table for corresponding provinces text file “ ID number two top corresponding provinces ”

stay “ Value mapping ” Components , Set as follows ：

 

stay “ grouping ” Components , Set as follows ：

 

  perform , The result is shown in the figure :

 

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

边栏推荐

猜你喜欢

随机推荐