table()

table(col [, ...cols]) removes all columns except the ones specified.

Returns

A table with the same number of rows, but with only the columns named in cols. If a row does not have a value for a column named in cols, its value for that column is null instead.

Examples

# Return only the requestId field and userAgent fields,
# out of log events that have the former
requestId:* | table requestId, userAgent