今天给大家介绍一下split out节点。这种节点顾名思义就是把数据进行拆分出来，形成一个个对象，方便后面的节点进行循环执行使用。比如我们举个场景，假设我们现在上游节点获取到了一组json数据，例如：
[
{
"aisms_tags": [
{
"userid": 10130,
"smsid": 880,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 881,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 882,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 883,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 884,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 886,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 887,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 888,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 889,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 890,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 891,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 892,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 893,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 894,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 895,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 896,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 898,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 899,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 900,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 901,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 902,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 903,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 904,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 905,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359615,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359616,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359617,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359618,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359619,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359620,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359621,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359622,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359623,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359624,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359625,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359626,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359627,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359628,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359629,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359630,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359631,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359632,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359633,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359634,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359635,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359636,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359637,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359638,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359639,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"_smsid": 6359640,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359641,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359642,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359643,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359644,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359645,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359646,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359647,
"collectionType": "REPAYMENT"
},
{
"userid": 10130,
"smsid": 6359648,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359649,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359650,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359651,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359652,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359653,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359654,
"collectionType": "COLLECTION"
},
{
"userid": 10130,
"smsid": 6359655,
"collectionType": "REPAYMENT"
},
{
"userid": 10130,
"smsid": 6359656,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359657,
"collectionType": "REPAYMENT_TIPS"
},
{
"userid": 10130,
"smsid": 6359658,
"collectionType": "OTHER"
},
{
"userid": 10130,
"smsid": 6359659,
"collectionType": "REPAYMENT_TIPS"
}
]
}
]像这个json字段，我们可以看到一级数组下面只有1个对象aisms_tags，但是我们需要aisms_tags对象的值，他的值是一个数组，我们需要把这个数组给切分出来，让mysql节点进行循环插入数据，那怎么办呢？这个时候就要用到这里的split out节点，他很简单，只需要填写我们需要切分的key，他就会自动进行切分，下面演示下：
直接从右侧添加一个节点
然后添加进去之后，只需要配置一个Fields to split out字段即可，如下图
看提示，他让我们拖拽对应的key过去就可以了，我们直接根据上一步的输入，把对应的aisms_tags拖过去即可：
然后我们点击测试，可以看到右侧就把对应的数据给切分出来了，最终形成了1级数组中有多个object对象。是不是很方便？以上就是split out节点的使用。比较简单，主要用作数据切分重组，方便后面的节点使用。
还没有评论，来说两句吧...