KETTLE 读取文本信息添加时间字段

叁歲伎倆 2022-01-17 02:39 1153阅读 0赞

转换： [https://blog.csdn.net/care\_about\_people/article/details/44960193][https_blog.csdn.net_care_about_people_article_details_44960193]

KETTLE 读取文本信息添加时间字段:  [https://blog.csdn.net/Care\_about\_people/article/details/44960193][https_blog.csdn.net_Care_about_people_article_details_44960193]

kettle从数据库添加要求指定的日期内的数据，并且时间实现自增模式:  [https://blog.csdn.net/Mr\_Tanga/article/details/81084234][https_blog.csdn.net_Mr_Tanga_article_details_81084234]

[kettle之时间字段默认值为空或’0000-00-00’问题][kettle_0000-00-00]:  [https://www.cnblogs.com/janehoo/p/5648876.html][kettle_0000-00-00]

KETTLE字段转换实例:  [https://www.2cto.com/net/201712/704271.html][https_www.2cto.com_net_201712_704271.html]

**本地几个文件，用kettle 抽到库里后面加个加载时间**

**网上找了好久都没有具体的描述，记录下来希望能帮助到你。**

例子截图如下：

![20150409150921510][]

![20150409150947285][]

![20150409151011527][]![20150409151101819][]![20150409151105906][]

[https_blog.csdn.net_care_about_people_article_details_44960193]: https://blog.csdn.net/care_about_people/article/details/44960193
[https_blog.csdn.net_Care_about_people_article_details_44960193]: https://blog.csdn.net/Care_about_people/article/details/44960193
[https_blog.csdn.net_Mr_Tanga_article_details_81084234]: https://blog.csdn.net/Mr_Tanga/article/details/81084234
[kettle_0000-00-00]: https://www.cnblogs.com/janehoo/p/5648876.html
[https_www.2cto.com_net_201712_704271.html]: https://www.2cto.com/net/201712/704271.html
[20150409150921510]: /images/20220117/7ae792c621bc4bd6a361f79be0b35237.png
[20150409150947285]: /images/20220117/d057cc4843fa47a8931c6491f834ba4b.png
[20150409151011527]: https://img-blog.csdn.net/20150409151011527
[20150409151101819]: https://img-blog.csdn.net/20150409151101819
[20150409151105906]: /images/20220117/c3cb423df5354259ac63a37db2e8693a.png