Json Jolt：数组中两个字符串的连接

发布于09月15日

我正在try 连接数组中的两个字符串，并try 了In Jolt.我放不出go :

输入内容为:

[
  {
    "policy": "Name",
    "setFrstNm": "John"
  },
  {
    "setLastNm": "Jammy",
    "policy": "Name"
  },
  {
    "policy": "Name",
    "set1FrstNm": "sam"
  },
  {
    "policy": "Name",
    "set1LastNm": "jim"
  },
  {
    "policy": "Name",
    "set2FrstNm1": "jun"
  },
  {
    "set2LastNm1": "san",
    "policy": "Name"
  }
]

所需输出应为:

[
  {
    
    "setfullname": "John jammy"
     "policy": "Name",
  },
  
  {
    "set1fullname": "sam jim",
    "policy": "Name",
  },
  {
    "set2fullname": "jun san",
    "policy": "Name",
  },
  
]

我被试了一盘

[
  {
    "operation": "modify-default-beta",
    "spec": {
      "*": {
        "setfullname": "=concat(@(1,setFrstNm),' ',@(1,setLastNm))"
        "policy": "Name"
      }
    }
  },

推荐答案

重要的是确定分组标准，以便形成即将到来的对象将取决于

[
  { // group by Last/Frs removed key names 
    "operation": "shift",
    "spec": {
      "*": {
        "*Last*": {
          "@": "@2,policy.&(1,1).&(1,1)fullname" // in &(1,1) : the first 1 represents going 1 level up the tree
                                                 //             the second 1 represents the replacement for the 1st asterisk 
        },
        "*Frs*": {
          "@": "@2,policy.&(1,1).&(1,1)fullname"
        }
      }
    }
  },
  { // concatenate the pairs by their key names respectively 
    "operation": "modify-overwrite-beta",
    "spec": {
      "*": {
        "*": {
          "*": "=join(' ',@(1,&))"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "*": "[#2].&",
          "$1": "[#2].policy" // deliver back the policy attribute to those objects
        }
      }
    }
  }
]

现场http://jolt-demo.appspot.com/上的101个是: