Hello All,
I am running below query on a document(having arrays) and getting below OP. But I need to get output as desired below.
Any help is appreciated.
select
ARRAY A.name.fname FOR A IN mn.B END fname,
ARRAY A.name.lname FOR A IN mn.B END lname,
ARRAY A.name.remark FOR A in mn.B END
from bucket mn
where ?
Current Output:
remark fname lname
[“name of student… halpart/jim”,“NAME of student… scott/micheal”] [“jim”,“oscar”,“kevin”,“dwight”] [“halpart”,“martinez”,“malone”,“schrute”]
desired Output :
remark fullname (elemnts of fname+element of lname)
[“halpart/jim”,“scott/micheal”] [ “jim halpart”,“oscar martinez”,“kevin malone”,“dwight schrute”]