Join two lookups to get accurate result count

[architkhanna]

Hi,

I have below scenario:

kvlookup 1: has list of resolved as well as Unresolved tickets. This has many fields
lookup2: has just unresolved tickets( pulled up from a scripted input, This shall contain tickets part of first lookup and is a subset of it). This has just ticket number and ticket states relevant from kvlookup1

How can I join both of these to have a complete list of accurate unresolved and resolved tickets.
lookup1 will always have more records and is a superset of lookup 2 

[scelikok]

Hi @architkhanna,

Since there is no info about lookup names, field names etc. I can only give an idea like below;

You can use lookup command to add fields from lookup2 to the result of lookup1. I assumed the ticketID is common id field.

| inputlookup kvlookup1 
| lookup lookup2 ticketID OUTPUT status
| table ticketID status

[architkhanna]

hello, Thanks for the response.
however, lookup 1 has ticket number and all possible fields related to the ticketing info,
while lookup2 has just ticket number(which shall be present in lookup 1 as well but) and a few other columns that shall not be matching with lookup1.Also do note lookup 2 just has UNRESOLVED tickets while Lookup 1 has BOTH resolved and Unresolved.

Motive here is to get accurate list of all unresolved and resolved  tickets because lookup2 will have current unresolved tickets in source system while lookup1 will have tickets that has moved out of source but yet not flown into index with updates(and will never , hence they will remain unresolved always on dashboard)