Get rid of " ", "result", "table" columns

Hello,
I’m new in flux, i made a simple query with no problems.
But there are three columns i’d like to don’t have in my CSV
Is it possible in a simple flux query to get rid of the first three columns ("", “result”, “table”) ?

So far here is my query

from(bucket: “instance_audit_trail/autogen”)
|> range(start: -1y)
|> filter(fn: ® => r._measurement == “learner_modification” )
|> keep(columns: ["_time", “_value”, “_field”, “_measurement”, “action”])
|> drop(columns: ["", “result”, “table”])

@CaoCao result and table are essentially “meta” columns that define how output data is structured. All annotated CSV returned from InfluxDB 2.0 will include those columns, even if you try to drop them.

Alright thanks a lot for your answer.
I manage to drop them by manipulating the string in the csv generated file.

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.