Compare data b/w 2 tables using kapacitor (tick script)

Welcome & Getting Started
, ,
1

Hi guys,

A part of my project wants me to compare data b/w 2 tables, if comparison is false then store the missing value in different table.

Table A
=======================================================
|timestamp          |IPAddress             |Value     |
=======================================================
|123456789          |192.168.5.2           |2         |
|123456788          |192.168.5.3           |4         |
|123456787          |192.168.5.4           |6         |
|123456786          |192.168.5.5           |8         |
=======================================================

Table B
=======================================================
|timestamp          |IPAddress             |Value     |
========================================================
|123456789          |192.168.5.2           |2         |
|123456788          |192.168.5.3           |4         |
=======================================================

Now if I compare these tables, the 2 missing IPs in table A needs to be saved in Table C.
I need to do these by Kapacitor. Or if you have any better suggestion then it will be great.

2

Hello @Aritra666B,
I think you could use join node will fill = null. Then you could filter for null values and write data elsewhere.