Fill(none) in flux to remove lines with null values

Hello,

It is mentioned here that fill can take none as a parameter and then it removes lines that have null value.
I couldn’t find this documented nor could I make it work - tried multiple variations.
Does this work in flux with 2.0? If it does, what is the syntax?
Thanks

:cricket:
Anyone knows how to remove empty lines? :pleading_face:

Hello @danbars,
Welcome!
Yes you can filter out null values with flux with exists
https://docs.influxdata.com/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/filter/#filter-out-null-values
I’m not sure why that’s not working for you. I would need to see some sample data as well as your query.
Also, may I ask why are you using 1.x instead of 2.x if you’re new to InfluxDB?

Thanks, @Anaisdg
I am using 2.x. I just couldn’t find the relevant docs in 2.0 so I referred to 1.x.
I’ll try what you suggested, thanks!

1 Like