Problem - Need an advise here....

[#1]

Hello

We have 2 tables:

1) Table 1 contains the column "Distance" and column "MeterID"  , There are 1700 MeterID and the distance is in intervals 0-0.5Miles, 0.5-1Miles, etc...

2) Table 2 contains the column "UnitID" which is same as "MeterID" (only different name) and column which name is "RSSI".

I created graph that lists the no. of MeterID's (y axis) in each distance interval , i.e 0-0.5 Mile - 30 Meters, 1-1.5 Miles 20 Meters etc

(this is based only on table 1)

need:

To Create another column name "RSSI" (from the second table) according to the distances intervals (from the first table)

Thanks

Oded

[#2]

forgot to mentioned that RSSI is a number

[Michiel_QV_Fan]

You need an interval match. This needs to match the UnitID value in the distance interval.

[saumyashah90]

Rename  UnitId as MeterID in the script

[Anonymous]

Load UnitID as MeterID and Qlik Sense will automatically connect the two tables on MeterID

[#6]

thanks

[#7]

thanks

[#8]

thanks