Hello! I’m very new to Couchbase and N1QL.
Here is a screenshot for my issue:
- Query result returns
custom_paramscolumn, which has various sub-columns
- How would I transform “# shifts this ship” into a proper column - such as
I looked through the N1QL language reference, but didn’t find an obvious answer - so thought I’d ask!
Edit: I wanted to mention specifically that currently, the data I’m trying to work with has a very poor naming convention. Notice that one of the sub columns is listed as “# shifts this ship” and not something like “NumShiftsThisShip”. This is where my problem is arising.