I have a search that returns hundreds of results. Each result contains a field called jobName and another field called server I need to build a table with 2 columns from a fixed set of JobNames. However, if one of the JobName in my defined list is not found in the search result, I need to return 'Not found'
Table should look like: JobName server JobA Server1 JobB Server2 JobE Not found JobX Server6
Can anyone please help on how to generate the output above? Thanks