Map function in flux where field name has spaces in between

InfluxDB 2
,
1

Guys am trying to use the map function but the way I have done them before is not working as the fields name has spaces in b/w & it’s giving error
Tried following ways but no avail
from(bucket: “RawData”)
|> range(start: -1h, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “DIAG”)
|> filter(fn: (r) => r[“_field”] == “Heatsink temperature : Heatsink temperature” or r[“_field”] == “Connection”)
|> pivot(rowKey: [“_time”], columnKey: [“_field”], valueColumn: “_value”)
|> map(fn: (r) => ({ r with _value: (r.Heatsink\ temperature\ :\ Heatsink\ temperature) }))
|> filter(fn: (r) => r[“Connection”] == “192.168.5.110”)
|> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
|> yield(name: “last”)

from(bucket: “RawData”)
|> range(start: -1h, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “DIAG”)
|> filter(fn: (r) => r[“_field”] == “Heatsink temperature : Heatsink temperature” or r[“_field”] == “Connection”)
|> pivot(rowKey: [“_time”], columnKey: [“_field”], valueColumn: “_value”)
|> map(fn: (r) => ({ r with transformed: r[“Heatsink temperature : Heatsink temperature”] }))
|> filter(fn: (r) => r[“Connection”] == “192.168.5.110”)
|> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
|> yield(name: “last”)

2

Hello @Aritra666B,
What error are you getting?
That bracket notation looks correct.
Make sure you’re using the correct quotes though.

"Company Name"

Straight quotes instead of curly.