Using AS to redefine a property in a dataview query

[ksdavidc]

What I’m trying to do

For example, imagine this:

TABLE WITHOUT ID NestedObject.name
FROM ""
WHERE file.name = this.file.name

Is there a way to use AS so as it can be written

TABLE WITHOUT ID N.property
FROM ""
WHERE file.name = this.file.name
....something that changes NestedObject to N

Things I have tried

Tried the dataview documentation but not sure what to search for…name? alias? variable? those are taken by other things.

[holroy]

If NestedObject is not a list you can use FLATTEN NestedObject as N. If it’s a list the previous would actually flatten the list into each element of that list. If you would like to rename a list, e.g. MyList, to somthing else, you could try FLATTEN list(MyList) as M.