Kettle解析LIST JSON数据

转载自 https://blog.csdn.net/u010758605/article/details/51655352

作为保存
遵循 CC 4.0 BY-SA 版权协议

JSON格式如下

{"list":[{"ref_date":"2016-06-12","user_source":0,"new_user":2,"cancel_user":14},{"ref_date":"2016-06-12","user_source":1,"new_user":3,"cancel_user":0},{"ref_date":"2016-06-12","user_source":17,"new_user":3,"cancel_user":0},{"ref_date":"2016-06-12","user_source":30,"new_user":7,"cancel_user":0}]}

kettle的JSON INPUT组件配置如下

$..list[*].ref_date
$..list[*].user_source
$..list[*].new_user
$..list[*].cancel_user