Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· OpenAIAi2 WildChat-4.8M (AI2)

使用groovy找到两个json数组中相同的数据,unionId是外键…

  1. 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"}]

  2. 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]]