Hi,
When I try to perform a join as shown below
import “array”
import “influxdata/influxdb/Sample”
import “join”
left =
sample.data(set: “First”)
|> filter(fn: (r) => r.Sno == 61 or r.Sno == 62 or r.Sno == 63)
|> filter(fn: (r) => r._field == “Second”)
|> limit(n: 5)
right =
array.from(
rows: [
{Sno: 61, State: “AP”, last_maintained: 2023-04-08T00:00:00Z},
{Sno: 62, State: “KA”, last_maintained: 2023-04-08T00:00:00Z},
],
)
join.inner(
left: left |> group(),
right: right,
on: (l, r) => l.Sno == r.Sno,
as: (l, r) => ({l with State: r.State, maintained: r.last_maintained}),
)
|> group(columns: [“State”])
It is giving an error as “Invalid import path join error”.
Regards
Sudheer
