Hey, im trying to do something relative easy and for some reason can't make it.. i have a lookup named tableq_lookyp with only one column tableq with the values: 1,2,4,5,7,8,10,11,12,13,14,15,16,20,21,22 (each value is different row) and i have this search: index=myidnex sourcetype=mysourcetype source=mysource
| table ACCUM_CODE LOCK_CODE PERIOD_KEY TABLEQ UPD_DATE UPD_TIME USER_NAME i want to check if all of the values from the tableq lookup exists in my search so i should get 16 rows (as the amount of different values in tableq) and a new column with yes/no options that tell me if the value appear in the search/lookup or not what is the best way of doing it? thanks !
... View more