Hi Have data as below.I want to Extract "Name" value from Col B - if the "id" match in Column A & Col B.
Here - the output for Col C would be CAM,RET,INS.
I used JsonGet(Col B, '/items/0/name') to extract "CAM" from Col B.
| Col A |
Col B |
Col C |
| { |
{ |
|
| "itemValues": [ |
"items": [ |
|
| { |
{ |
|
| "id": "k2bzNXcPunqzZpqlo2JBrg", |
"id": "k2bzNXcPunqzZpqlo2JBrg", |
|
| "status": "Selected" |
"name": "CAM" |
|
| }, |
}, |
|
| { |
{ |
|
| "id": "meoXkB6EXAg1HtEULphIyw", |
"id": "meoXkB6EXAg1HtEULphIyw", |
|
| "status": "Selected" |
"name": "RET" |
|
| }, |
}, |
|
| { |
{ |
|
| "id": "kR5JqjL50XIgP_a_JQ5B_Q", |
"id": "kR5JqjL50XIgP_a_JQ5B_Q", |
|
| "status": "Selected" |
"name": "INS" |
|
| } |
}, |
|
| ] |
{ |
|
| } |
"id": "os5u2-KW9aOm8wuat_RJDQ", |
|
| |
"name": "Water" |
|
| |
}, |
|
| |
{ |
|
| |
"id": "vlluUqoAUcTfuqVcXJZC7Q", |
|
| |
"name": "Electricity" |
|
| |
}, |
|
| |
{ |
|
| |
"id": "qYaD20UYW7-NiZUDErlAtg", |
|
| |
"name": "Security" |
|
| |
}, |
|
| |
{ |
|
| |
"id": "jQrI9N1nlzjqYPhdablDMg", |
|
| |
"name": "Parking" |
|
| |
}, |
|
| |
{ |
|
| |
"id": "gGweWt_WEt05FJowTPRJNQ", |
|
| |
"name": "Utilities" |
|
| |
}, |
|
| |
{ |
|
| |
"id": "pMPGWzEXfZNHbmg0rf5OUw", |
|
| |
"name": "Other" |
|
| |
} |
|
| |
] |
|
| |
} |
|
