Merging Two tables to fetch the report in List View

[Tejaswini Shirs]

We have a requirement, where we need to merge two tables based on OA(s) column, where OA is a List Collector field on table A (Highlighted in green as shown in SC).

Table B is highlighted in Blue, based on OA(S) field we have to pull data from table B. 

we have to merge tables A and B and show it in the List form as shown in the above screenshot.

For example: If product ABC is mapped with three OA(s), then we need to display three-row with the same product data having unique mapped application details (PROD ID, APP ID, AS) like TEST1, TEST2, and TEST3.

[EricDohr]

Any chance both tables are configuration item classes?  You could use CMDB Query Builder to obtain the two tables and logic.  Once you save, schedule a report, this will make a data source from both tables that you can use.  

[Tejaswini Shirs]

Thanks for the reply!

Tables are not configuration item classes, they are the custom table starting with u_tablename.

[EricDohr]

If you are an admin, you could create what is known as a database view.  Here is a docs page (and sub pages) which may help out

https://docs.servicenow.com/en-US/bundle/tokyo-platform-administration/page/use/reporting/concept/c_...

[Tejaswini Shirs]

We tried it creating a Database view, but we get stuck on Owned Application field as per show in the attached SC. it is the list collector field-based that that field we have to segregate the data.
the field contains comma-separated values, we want to separate them, and show separate data for each value.