How to join two tables that have different column values


I have two tables with different tags, one is called “test_id” and the other is “TestID”, and I want to join them on that tag. Please help me.

Hello @shrav,
Welcome! You could use the map() function to rename your columns and then perform a join.

|> map(fn: (r) => ({
    r with
      if r["mytag"] == "test_id" then "TestID"
      else r["mytag"]