Trying to join multiple measurements

Fluxlang
4

I just solved:

from(bucket: "real-data")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "STATUS" or r["_measurement"] == "TYPE")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> pivot(rowKey:["_time"], columnKey: ["_measurement"], valueColumn: "_value")  
  |> fill(column: "STATUS", usePrevious: true)
  |> fill(column: "TYPE", usePrevious: true)
  |> yield(name: "last")

I was not using “COLUMN” on fill.

Thank you for your help @fercasjr