Could someone give me a hint how to nest a unnested data structure? I tried all sorts of approuches, however still did not get exactly what I wanted.
I have a bucket with unnested documents, like:
And I would like to have something like:
One off the things I tried is stated below, however, in this case I also have the ID field in the nested data, which I don’t need / want.
FROM Accounts AS Body
Join (Select ID, InvoiceAddress, InvoiceAddressPostCode, InvoiceCity, InvoiceCountry, InvoiceState From Accounts) AS Address on Body.ID = Address.ID