i have look table with known errors and planning to create job which runs on cron schedule and provide me list of error with high count ( example error 1, error 2, error 3). Do we know way to compare my error ( error 1 , error 2 , error 3) with lookup table , get a result if these error 1,2,3 were not matching with my known errors from my lookup table ?
search for errors here | join key [inputlookup error_lookup] | table *