Group together all the row of a CSV according to the uploaded date

n1ql
query

#1

I’m uploading a CSV file to couchbucket row by row. Now i want to show the data all the row of a file in table form but when i’m running the query it is showing all the rows of all the files uploaded into coucbucket in that particular date.

My query is : select distinct Report.Data[0].Details[0] as Details from Report where Timestamp = “07 Jun 2018”


#2

Provide sample document and expected output
Use GROUP BY with ARRAY_AGG()