动态解析Kettle步骤中的json字段
直接上步骤
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsIiclRnblN2XjlGcjAzNfRHLGZkRGZkRfJ3bs92YsYTMfVmepNHL9kkaNVzaU1UMshFZvB3MMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2X0hXZ0xCMx81dvRWYoNHLrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnL0gzNzQzNwAjM2ETMxAjMwIzLc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
直接上代码
//Script here
//将json字段解析
var optionsJson=JSON.parse(similarfaces);
//遍历其中的数据
for(var i=0;i<optionsJson.length;i++)
{
//取出结构化数据并塞入输出步骤中
var outputRow = new Array(_step_.getOutputRowMeta().size());
var data = optionsJson[i];
var outputRow = new Array(_step_.getOutputRowMeta().size());
outputRow[_step_.getOutputRowMeta().indexOfValue("data_id")] =data_id;
outputRow[_step_.getOutputRowMeta().indexOfValue("datatype")] =datatype;
outputRow[_step_.getOutputRowMeta().indexOfValue("channelId")] =channelid;
outputRow[_step_.getOutputRowMeta().indexOfValue("channelName")] =channelname;
outputRow[_step_.getOutputRowMeta().indexOfValue("capTime")] =captime;
outputRow[_step_.getOutputRowMeta().indexOfValue("faceImgUrl")] =faceimgurl;
outputRow[_step_.getOutputRowMeta().indexOfValue("faceImgUrlEx")] =faceimgurlex;
outputRow[_step_.getOutputRowMeta().indexOfValue("imgUrlEx")] =imgurlex;
outputRow[_step_.getOutputRowMeta().indexOfValue("alarmId")] = data.alarmId;
outputRow[_step_.getOutputRowMeta().indexOfValue("alarmType")] = data.alarmType;
outputRow[_step_.getOutputRowMeta().indexOfValue("gender")] = data.gender;
outputRow[_step_.getOutputRowMeta().indexOfValue("idNumber")] = data.idNumber;
outputRow[_step_.getOutputRowMeta().indexOfValue("name")] = data.name;
outputRow[_step_.getOutputRowMeta().indexOfValue("repositoryId")] = data.repositoryId;
outputRow[_step_.getOutputRowMeta().indexOfValue("repositoryName")] = data.repositoryName;
outputRow[_step_.getOutputRowMeta().indexOfValue("similarity")] = data.similarity;
outputRow[_step_.getOutputRowMeta().indexOfValue("targetFaceImgId")] = data.targetFaceImgId;
outputRow[_step_.getOutputRowMeta().indexOfValue("targetFaceImgUrl")] = data.targetFaceImgUrl;
outputRow[_step_.getOutputRowMeta().indexOfValue("targetFaceImgUrlEx")] = data.targetFaceImgUrlEx;
outputRow[_step_.getOutputRowMeta().indexOfValue("targetImgUrl")] = data.targetImgUrl;
outputRow[_step_.getOutputRowMeta().indexOfValue("targetImgUrlEx")] = data.targetImgUrlEx;
outputRow[_step_.getOutputRowMeta().indexOfValue("vendor")] = data.vendor;
_step_.putRow(_step_.getOutputRowMeta(), outputRow);
}
var trans_Status = SKIP_TRANSFORMATION;