How to join two tables that have different column values

Welcome & Getting Started
1

Hi,

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.

2

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

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