I have two searches: search-A gives values like type status hostname id port Size base cache http OFF host-1 17 NA NA NA NA http ON host-1 6 NA NA NA NA http ON host-1 15 NA NA NA NA http OFF host-1 1 NA NA NA NA web OFF host-2 17 NA NA NA NA web ON host-2 6 NA NA NA NA http ON host-3 15 NA NA NA NA http OFF host-3 1 NA NA NA NA Search-B gives value like type status hostname id port Size base cache available not_processed host-1 17 NA NA NA NA available not_processed host-2 17 NA NA NA NA available not_processed host-4 15 NA NA NA NA available not_processed host-5 1 NA NA NA NA I want to merge two search in such a way that it can check hostname in search-B and if hostname is present in search-A the it should not join/merge that row.. the result should be something like below... type status hostname id port Size base cache http OFF host-1 17 NA NA NA NA http ON host-1 6 NA NA NA NA http ON host-1 15 NA NA NA NA http OFF host-1 1 NA NA NA NA web OFF host-2 17 NA NA NA NA web ON host-2 6 NA NA NA NA http ON host-3 15 NA NA NA NA http OFF host-3 1 NA NA NA NA available not_processed host-4 15 NA NA NA NA available not_processed host-5 1 NA NA NA NA
... View more