工作流程
事件流程
逻辑问题修正
如:父级信息:
[{
"shenfenming": "H北京市",
"shenfenbianhao": "1" //父级信息id
}, {
"shenfenming": "H安徽省",
"shenfenbianhao": "2"
}, {
"shenfenming": "H广东省",
"shenfenbianhao": "3"
}];
则子级信息必为:
[{
"shiquming": "H海淀区",
"shiqubianhao": "a1",
"shenfenid": "1" //对应父级id
}, {
"shiquming": "H朝阳区",
"shiqubianhao": "b1",
"shenfenid": "1"
}, {
"shiquming": "H密云区",
"shiqubianhao": "c1",
"shenfenid": "1"
}, {
"shiquming": "H合肥市",
"shiqubianhao": "a2",
"shenfenid": "2" //对应父级id
}, {
"shiquming": "H六安市",
"shiqubianhao": "b2",
"shenfenid": "2"
}, {
"shiquming": "H马鞍山市",
"shiqubianhao": "c2",
"shenfenid": "2"
}, {
"shiquming": "H广州市",
"shiqubianhao": "a3",
"shenfenid": "3"
}, {
"shiquming": "H朝阳市",
"shiqubianhao": "b3",
"shenfenid": "3"
}, {
"shiquming": "H汕头市",
"shiqubianhao": "c3",
"shenfenid": "3"
}];
3.1 多级联动数据来源,设置为tmp_data

3.2 设置多级联动表名:
数据来源中的表名,设置父级数据存储位置,子级数据存储位置;

设置表间关联字段
添加默认值,默认值根据需要添加
3.3 删除代码段中多余的点

4.1 数据直接采集到tmp_data中
4.2 数据输出介绍
{
"shenfenbiao": [{
"shenfenming": "H北京市",
"shenfenbianhao": "1"
}, {
"shenfenming": "H安徽省",
"shenfenbianhao": "2"
}, {
"shenfenming": "H广东省",
"shenfenbianhao": "3"
}],
"shiqubiao": {
"1": [{
"shiquming": "H海淀区",
"shiqubianhao": "a1",
"shenfenid": "1"
}, {
"shiquming": "H朝阳区",
"shiqubianhao": "b1",
"shenfenid": "1"
}, {
"shiquming": "H密云区",
"shiqubianhao": "c1",
"shenfenid": "1"
}],
"2": [{
"shiquming": "H合肥市",
"shiqubianhao": "a2",
"shenfenid": "2"
}, {
"shiquming": "H六安市",
"shiqubianhao": "b2",
"shenfenid": "2"
}, {
"shiquming": "H马鞍山市",
"shiqubianhao": "c2",
"shenfenid": "2"
}],
"3": [{
"shiquming": "H广州市",
"shiqubianhao": "a3",
"shenfenid": "3"
}, {
"shiquming": "H朝阳市",
"shiqubianhao": "b3",
"shenfenid": "3"
}, {
"shiquming": "H汕头市",
"shiqubianhao": "c3",
"shenfenid": "3"
}]
}
}