MainTable
=======================================================
|timestamp |IPAddress |
=======================================================
|123456789 |192.168.5.2 |
|123456788 |192.168.5.3 |
|123456787 |192.168.5.4 |
|123456786 |192.168.5.5 |
=======================================================
LiveStatusTable
=======================================================
|timestamp |IPAddress |Value |
========================================================
|123456789 |192.168.5.2 |1 |
|123456788 |192.168.5.3 |1 |
=======================================================
Now I need to compare these tables to check which IPAddress are missing in the 2nd table using Flux.
Hi @Jay_Clifford ,
With Join I will get the common values. In my case I need to check which IP address are not in LiveStatusTable but are in the MainTable to determine whihc systems are offline.
Is there a way for me to do this using Flux?
Hi @Aritra666B,
I am wondering if you did an outer join between the two tables. This would then leave null values within rows where there is not a match. You could then use map() to conditional check if the two columns match one another.
Could you export your a sample of your data and I will see if I can build the query for you