Thanks Mr. @ttrodrigz
below is the conversion i'm looking for.
"user_master" : [
{ "ID": "ID101", "clasification": [{ "id": 1001, "loc": ["A1", "A2"] }, { "id": 1002, "loc": ["B1", "C2"] }] },
{ "ID": "ID102", "clasification": [{ "id": 2001, "loc": ["C1", "A2"] }, { "id": 3002, "loc": ["C1", "C2"] }] },
{ "ID": "ID103", "clasification": [{ "id": 1001, "loc": ["A1", "C1"] }, { "id": 1002, "loc": ["B1", "C1"] }] }
]
"collection": [
{ "r_num": 1, "ID": "ID101", "name: "n1", "loc":"A1", "clasif": ?},
{ "r_num": 2, "ID": "ID101", "name: "n1", "loc":"C1", "clasif": ?},
{ "r_num": 3, "ID": "ID102", "name: "n2", "loc":"B1", "clasif": ?},
{ "r_num": 4, "ID": "ID102", "name: "n2", "loc":"C1", "clasif": ?},
{ "r_num": 5, "ID": "ID103", "name: "n3", "loc":"A2", "clasif": ?},
]
i need to derive the Clasif field from user_master
collect all "clasification$id" where "collection$loc" %in% "clasification.loc"
for eg.
the result "collection" should look like
"collection": [
{ "r_num": 1, "ID": "ID101", "name: "n1", "loc":"A1", "clasif": "1001"},
{ "r_num": 2, "ID": "ID101", "name: "n1", "loc":"C2", "clasif": "3002"},
{ "r_num": 3, "ID": "ID102", "name: "n2", "loc":"B1", "clasif": ""},
{ "r_num": 4, "ID": "ID102", "name: "n2", "loc":"C1", "clasif": "2001, 3002"},
{ "r_num": 5, "ID": "ID103", "name: "n3", "loc":"A2", "clasif": ""},
}