gpt-4-0314· OpenAI
WildChat-4.8M (AI2)
使用groovy找到两个json数组中相同的数据,unionId是外键…
- User
使用groovy找到两个json数组中相同的数据,unionId是外键 ,[{"employmentStatus":"4","employmentStatusStr":"在家务农","groupType":["脱贫劳动力","易地搬迁劳动力","农村低收入家庭劳动力","残疾人","退役军人"],"mobile":"15387951620","name":"测试","unionId":"o3gM46PsnFxqlbdLjWUy6BFTC0V4"},{"employmentStatus":"1","employmentStatusStr":"就业","groupType":["脱贫劳动力","易地搬迁劳动力","残疾人","高校毕业生","退役军人"],"mobile":"18318366777","name":"陈陈陈","unionId":"o3gM46PsnFxqlbdLjWUy6BFTC0hf"}] 和[{"name":"哈哈哈","unionId":"o3gM46PsnFxqlbdLjWUy6BFTC0V4"},{"name":"哈哈哈2","unionId":"o3gM46PsnFxqlbdLjWUy6BFTCMIJ"}]
- Assistant
您可以使用以下Groovy脚本找到两个json数组中具有相同unionId的数据:
import groovy.json.JsonSlurper def json1 = '[{"employmentStatus":"4","employmentStatusStr":"在家务农","groupType":["脱贫劳动力","易地搬迁劳动力","农村低收入家庭劳动力","残疾人","退役军人"],"mobile":"15387951620","name":"测试","unionId":"o3gM46PsnFxqlbdLjWUy6BFTC0V4"},{"employmentStatus":"1","employmentStatusStr":"就业","groupType":["脱贫劳动力","易地搬迁劳动力","残疾人","高校毕业生","退役军人"],"mobile":"18318366777","name":"陈陈陈","unionId":"o3gM46PsnFxqlbdLjWUy6BFTC0hf"}]' def json2 = '[{"name":"哈哈哈","unionId":"o3gM46PsnFxqlbdLjWUy6BFTC0V4"},{"name":"哈哈哈2","unionId":"a3gM46PsnFxqlbdLjWUy6BFTCMIJ"}]' def slurper = new JsonSlurper() def data1 = slurper.parseText(json1) def data2 = slurper.parseText(json2) def commonData = data1.findAll { item1 -> data2.any { item2 -> item1.unionId == item2.unionId } } println "Common data: ${commonData}"这段脚本首先将两个JSON数组解析为Groovy列表,然后使用
findAll方法从data1中筛选出与data2中具有相同unionId的元素。any方法对data2中的每个元素进行检查,以找到具有相同unionId的元素,如果找到任何匹配项,findAll将保留该数据。输出结果:
Common data: [[employmentStatus:4, employmentStatusStr:在家务农, groupType:[脱贫劳动力, 易地搬迁劳动力, 农村低收入家庭劳动力, 残疾人, 退役军人], mobile:15387951620, name:测试, unionId:o3gM46PsnFxqlbdLjWUy6BFTC0V4]]