4 tables addition


I have joined 4 tables and I am getting the output. I am trying to sum those 4 tables as below

|> map(fn: (r) => ({r with _value: (r._value_t1+r._value_t2+r._value_t3+r._value_t4)}))

it is showing the blank in the column. When I try to sum 2 tables it is showing the correct value.


I got the solution after doing some R&D.

First we have to add 2 tables (t1 & t2)
t3= join(tables: {t1: t1, t2: t2}, on: [“sample”,“state”])
|> map(fn: (r) => ({r with _value: (r._value_t1+r._value_t2)}))

next we have to add that t3 with t4
join(tables: {t3: t3, t4: t4}, on: [“Sample”])
|> map(fn: (r) => ({r with _value: (r._value_t3+r._value_t4)}))